Update From Another Table MySQL

UPDATE
    TableName1
SET
    TableName1.col1 = TableName2.col1,
    TableName1.col2 = TableName2.col2
FROM
    Some_Table AS TableName1
    INNER JOIN Other_Table AS TableName2
        ON TableName1.id = TableName2.id
WHERE
    TableName1.column3 = 'Yes'
Please Share