Saturday, April 25, 2020

Update Record with INNER JOIN SQL Server

General syntax for updating table by getting information from multiple tables..

UPDATE TableA
SET Col2 ..,
       ...
FROM TableA AS A
INNER JOIN TableB AS B ON B.Col1 = A.Col1
...
WHERE ...
 

No comments:

Post a Comment