MySQL 查询修改

update rw_techno_report a  join (select * FROM sql_results) as b 
on b.`code` = a.code  set  a.Project_Name=b.`name`;