UPDATE from SELECT using SQL

UPDATE
    TableName1
SET
    TableName1.col1 = TableName2.col1,
    TableName1.col2 = TableName2.col2
FROM
    TableName1
INNER JOIN
    TableName2
ON
    TableName2 = TableName2.id