Update Join Query
От
Daniel Futerman
Тема
Update Join Query
Дата
Msg-id
6ca02fc80806231243y6e4ea774x6ae4967fb8824447@mail.gmail.com
Список
Дерево обсуждения
Update Join Query "Daniel Futerman" <daniel.futerman@gmail.com>
Re: Update Join Query Mark Roberts <mailing_lists@pandapocket.com>
Re: Update Join Query Antonio Perez <renjin25@yahoo.com>
Re: Update Join Query Craig Ringer <craig@postnewspapers.com.au>
Re: Update Join Query Antonio Perez <renjin25@yahoo.com>
Hi,
Looking for the correct syntax for an UPDATE LEFT JOIN query in PostgreSQL.
The equivalent MySQL query is :
UPDATE
Foo f LEFT JOIN Goo g on f.Foo_ID = g.Goo_ID
SET
f.Foo_ID = g.Goo_ID
WHERE
f.Foo_ID IS NOT NULL;
When I try to run this in Postgres, i get the following error:
ERROR: syntax error at or near "LEFT"
Is it possible to have UPDATE JOIN queries in PostgreSQL?
Thanks.
Looking for the correct syntax for an UPDATE LEFT JOIN query in PostgreSQL.
The equivalent MySQL query is :
UPDATE
Foo f LEFT JOIN Goo g on f.Foo_ID = g.Goo_ID
SET
f.Foo_ID = g.Goo_ID
WHERE
f.Foo_ID IS NOT NULL;
When I try to run this in Postgres, i get the following error:
ERROR: syntax error at or near "LEFT"
Is it possible to have UPDATE JOIN queries in PostgreSQL?
Thanks.
В списке pgsql-general по дате отправления
