Update query by joining multiple tables.

Guys,

on page this

http://www.postgresql.org/docs/8.1/interactive/sql-update.html, it is not
specified if a join can be done between multiple tables to update a table, i
tried and it worked just fine for me. Something like this :

Infact update can work between multiple tables to... do something like :

UPDATE employees SET sales_count = a.sales_count FROM accounts as a
WHERE a.name = 'Acme Corporation'
AND employees.id = a.sales_person;

considering sales_count as a column in accounts table.

Regards,
Moiz