Re: [GENERAL] 3 tables join update

From: rihad <rihad(at)mail.ru>
Date: Sun Sep 30 2007 - 04:36:02 EDT

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.

---------------------------(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

Received on Sun Sep 30 04:39:15 2007