Re: [GENERAL] 3 tables join update

[rihad]

Richard Broersma Jr wrote:

--- rihad <[EMAIL PROTECTED]> 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.

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
      choose an index scan if your joining column's datatypes do not
      match