UPDATE b FROM tableA a JOIN tableB b ON a.a_id = b.a_id JOIN tableC c .... How to Update a MySQL Table Based on SELECT MAX() from a ...
stackoverflow.com