Most SQL servers’ UPDATE and SELECT query statements are like these:
UPDATE
t1
SET
t1.column1 = t2.column1
FROM
table1 AS t1
INNER JOIN table2 AS t2
BUT in MySQL, SET is at the last part of the query.
UPDATE
table1 AS t1
INNER JOIN table2 AS t2
ON t1.id = t2.id
SET
t1.column1 = t2.column1