Showing posts with label JOIN. Show all posts
Showing posts with label JOIN. Show all posts

Update Table using JOIN in SQL Server

Update a table value from another Table using JOIN Query in SQL Server

Code :
    UPDATE
        A
    SET
        A.Colx = B.Coly
    FROM
        Table1 A
    JOIN
        Table2 B ON A.col1 = B.col5
    WHERE
        A.Col3 = 'xyz'

Gadget

This content is not yet available over encrypted connections.