To use when there’s the need to update a table with values from another table using a column match (join).
UPDATE TABLE1
SET Colum1 = T2.Column1
FROM TABLE1 T1
INNER JOIN TABLE2 T2 ON T1.MatchID = T2.MatchID
To use when there’s the need to update a table with values from another table using a column match (join).
UPDATE TABLE1
SET Colum1 = T2.Column1
FROM TABLE1 T1
INNER JOIN TABLE2 T2 ON T1.MatchID = T2.MatchID
No Comments
You can leave the first : )