| Posted at: 10:54 AM |
Filed Under: sql server
I found something useful when I am trying to update columns in a master table (tbl1) from data in a temp table (tbl2). These updates can be done by making a query to update a table by doing INNER JOIN.
Below is the example of a joined update query:
UPDATEtbl1 SETfield_name = B.field_name FROMtbl1 A INNER JOINtbl2 B ONA.ID = B.ID