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