How can I update 2 tables while doing inner join MySql? - Stack ...

The general syntax of what you want is: UPDATE table1 AS t1 JOIN table2 AS t2 ON SET ...

stackoverflow.com