MySQL Update Column From Another Table Based On Where Clause

February 17, 2019 9:21 pm by ATS Staff

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