update語句多表關聯

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