mysql把查询后的数据更新到另一张表
update tableA A inner join (select * from tableB where ...) B on B.XX = A.XX AND B.XX2 = A.XX2 AND .
mysql把查询后的数据更新到另一张表
update tableA A inner join (select * from tableB where ...) B on B.XX = A.XX AND B.XX2 = A.XX2 AND .