--- El lun 23-jun-08, Daniel Futerman <[EMAIL PROTECTED]> escribió: De: Daniel Futerman <[EMAIL PROTECTED]> Asunto: [GENERAL] Update Join Query A: pgsql-general@postgresql.org Fecha: lunes, 23 junio, 2008, 4:43 pm
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. sorry the last message have a error try whit this update foo set Foo_ID = goo.Goo_ID from goo where goo.Goo_id = foo.Foo_id and foo_ID IS NOT NULL;
