UPDATE from SELECT in SQL Server

Normally people think UPDATE statement runs only for a single table but for scenario when we have to check multiple values in a multiple table then we cannot use update statement. Well folks it’s just a myth & we can use it while joining multiple tables.

Please check given below sample query to update the records while joining multiple tables

UPDATE
    T
SET
    T.col1 = OT.col1,
    T.col2 = OT.col2
FROM
    Some_Table T
INNER JOIN
    Other_Table OT
ON
    T.id = OT.id
WHERE
    T.col3 = 'some value'

Hopefully it will work for you. Cheers