Re: 3 tables join update

Richard Broersma Jr wrote:
> --- rihad  wrote:
>> UPDATE Foo foo
>> SET foo.baz_id=baz.id
>> FROM Baz baz LEFT JOIN Bar bar ON (foo.bar_id=bar.id)
>> WHERE bar.id IS NULL;
> 
> This query cannot work.


I know. So how do I do it efficiently?

Thanks.