SQL Server Interview Question: How to Update a table, Table 1 from another table, 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