Update one table from another using join - SQL Snipplr Social Repository

Revision: 29924

at August 5, 2010 05:43 by lance

Initial Code

UPDATE U
SET TableToUpdateCol = TableFromCol
FROM TableToUpdate U
JOIN TableFrom ON TableToUpdatePK = TableFromPK

Initial URL

Initial Description

Initial Title

Update one table from another using join

Initial Tags

Initial Language

SQL