Update Join Query

Hi,

Looking for the correct syntax for an UPDATE LEFT JIN query in PostgreSQL.

The equivalent MySQL query is :

UPDATE
Foo f LEFT JIN Goo g on f.Foo_ID = g.Goo_ID
SET
f.Foo_ID = g.Goo_ID
WHERE
f.Foo_ID IS NT NULL;


When I try to run this in Postgres, i get the following error:

ERRR: syntax error at or near "LEFT"

Is it possible to have UPDATE JIN queries in PostgreSQL?

Thanks.