MYSQL 查询并更新sql

update table1 a 

inner join (select * from table2 where id=1) b 

on a.id=b.id

set a.name='1'