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
Labels:
SQL
Subscribe to:
Posts (Atom)