MySQL Update Column From Another Table Based On Where Clause


UPDATE	table1, table2
SET 	table1.column_to = table2.column_from
WHERE 	table1.column_where1 = table2.column_where2