Mega Code Archive

 

Categories / MSSQL Tutorial / Insert Delete Update

 

Syntax of UPDATE with a Join

UPDATE <modified_table>   SET col1 = <new_value>[,   col2 = <new_value>] [FROM     <modified_table>  <join_type> JOIN    <another_table> ON <join_condition>] WHERE <search_condition>]