Showing posts with label SQL. Show all posts
Showing posts with label SQL. Show all posts

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