SQL Server Statement to Update Table 1 from Table 2

The below SQL statement is an update statement that updates a table named TABLE1 from another table TABLE2

UPDATE [TABLE1] 
   SET [TABLE1].[COLUMN1] = [TABLE2].[COLUMN1]
FROM 
   [TABLE2]
WHERE 
   [TABLE2].[COLUMN1] = 'SOME VALUE'

Popular Tutorials