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
