JOIN UPDATE (mssql)

UPDATE TABLE1 SET COL1 = A.COL1
FROM    TABLE1 AS A
INNER JOIN TABLE2 AS B
            ON A.KEYCOL = B.KEYCOL