update table1 a set a.ziduan = (select b.newziduan from table2 b where b.id = a.id)
update语句多表关联
于 2018-03-06 20:26:42 首次发布
update table1 a set a.ziduan = (select b.newziduan from table2 b where b.id = a.id)