update table1 set mc=(select mc||mc1 from table1,table2 where table2.id=table1.iid)
where id = (select table1.id from table1, table2 where table1.id=table2.id)
哈哈,我想应该是这样的:
update talbe1 a set a.mc=(select b.mc1 from table2 b,table1 a where a.id=b.id) +a.mc where a.id in (select a.id from table1 a, table2 b where a.id=b.id)