[GENERAL] What is the syntax for UPDATE from one table to another?

[pw]

Hello,

What is the proper syntax for updating a column inone table from
a column in another?
I have tried this:

UPDATE destination_table FROM source_table SET 
destination_table.column_one = source_table.column_b WHERE constraint;

This fails, so I must have the syntax incorrect.

Thanks for any help,

Pete





---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
              http://www.postgresql.org/docs/faqs/FAQ.html