How to update one table field with the help of more than one table in SQL Server 2000
How to Update one table field with the help of more than one table
Software/Hardware used:
SQL Server 2000
Software/Hardware used:
SQL Server 2000
ASKED:
October 4, 2010 10:25 AM
UPDATED:
October 4, 2010 2:27 PM
Answer Wiki:
Something like this might be what you want:
<pre>UPDATE
Table
SET
Table.col1 = other_table.col1,
Table.col2 = other_table.col2
FROM
Table
INNER JOIN
other_table
ON
Table.id = other_table.id </pre>
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
