rihad wrote:
Richard Broersma Jr wrote:
UPDATE Foo foo
SET ...
FROM LEFT JOIN Bar bar USING(common_field)
WHERE blah='blah' AND bar.common_field IS NULL;
ERROR: syntax error at or near JOIN
I know I'm misusing UPDATE ... FROM because I don't really want Bar's
values to go into Foo,
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
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. Basiclly, you are trying to set the foo.baz_id =
baz.id for records in
foo that do not yet
Hi,
Say I want to update table Foo with data in table Bar iff left join
between Foo and yet another table Baz finds no match.
UPDATE Foo foo LEFT JOIN Bar bar ON (foo.bar_id=bar.id)
SET foo.baz_id=baz.id
FROM Baz baz
WHERE bar.id IS NULL;
ERROR: syntax error at or near LEFT
UPDATE Foo foo
--- 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. Basiclly, you are trying to set the foo.baz_id =
baz.id for records in
foo that do not yet exist. Doing this is