update语句多表关联

update table1 a set a.ziduan = (select b.newziduan from table2 b where a.id = b.id)