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'