Home Forums SQL Server 2008 T-SQL (SS2K8) UPDATE SELECT RE: UPDATE SELECT
John Mitchell-245523
SSC Guru
Points: 148809
More actions
January 27, 2011 at 8:47 am
#1279130
UPDATE t2
SET column1 = t1.column1, column2 = t1.column2,...
FROM table1 t1 JOIN table2 t2
ON t1.ID = t2.ID
John