mysql - UPDATE (SELECT ... ) SET ... - Stack Overflow

Try: UPDATE Table1 SET column1 = t2.Column FROM table1 t1 JOIN (SELECT .. . FROM ... lots of joins etc) t2 ON t1.id = t2.otherid ...

stackoverflow.com