SQL- Update one table from another with inner join

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 : )



Leave a Reply

Your email address will not be published. Required fields are marked *