------解决方案-------------------- update table2 tt set tt.age = (select v.age from (select t1.id, t1.name, (select t.age from table1 t where t.name = t1.name) age from table2 t1) v where v.id = tt.id) 不知道是否可以,数据量大的话,这样的更新感觉会比较耗时
------解决方案-------------------- 2种写法??? 来个update 来个merge么 哈哈
------解决方案-------------------- Have a try.[code=SQL] update table2 set table2.age = (select table1.age from table1 where table1.name = table2.name);code]
------解决方案--------------------