Update using Join in sql server

 In this article we learn how can we update multiple records using joins in sql server.

Update TableA  

SET 

       TableA.Column_name=TableB.Column_name

FROM 

       TableA 

LEFT JOIN 

       TableB 

ON 

       TableA.ID=TableB.ID