mysql - SQL UPDATE with INNER JOIN - Stack Overflow
https://stackoverflow.com/questions/14491042/sql-update-with-inner-join
MySQL UPDATE JOIN | Cross-Table Update in MySQL
http://www.mysqltutorial.org/mysql-update-join/
原文：https://www.cnblogs.com/rgqancy/p/10225393.html