Re: 3 tables join update

[rihad <rihad(at)mail(dot)ru>]

Richard Broersma Jr wrote:
> --- rihad <rihad(at)mail(dot)ru> 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.