Update with a JOIN statement

[hc]

Any idea why this returns an error of

ERROR:  syntax error at or near "ims" at character 27

UPDATE imports.menssoccer ims
SET employee_id = uem.id
FROM ims
JOIN users.employees uem ON ims.ssn = uem.tax_id

Any help would be appreciated. Thanks

hc

[btherl]

I don't think you can give an alias to the table being updated.

How about:
UPDATE imports.menssoccer
SET employee_id = uem.id
FROM users.employees uem
WHERE employee_id = uem.tax_id

[hc]

that works thank you very much