Thanks to everyone who helped. I found the solution just by tooling with the SQL syntax.
FYI, the correct syntax is:
UPDATE destination_table SET dest_column=A FROM (SELECT src_column as A, src_link_col FROM src_table) AS J WHERE src_link_col=dst_link_col;
Pete
pw wrote:
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
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
