Friday, November 13, 2009

How to Update value with JOIN in SQL query?


UPDATE
    table1
SET
    table1.column1=table2.column1
FROM
    table1
INNER JOIN (ANY JOIN)
    table2
ON
    table1.key=table2.key

No comments:

Post a Comment