34,590
社区成员
发帖
与我相关
我的任务
分享
update T1 set T1.country=T2.country,T1.continent=T2.continent
FROM T1 ,T2
where T1.id=T2.recid
update T1 set country=T2.country,continent=T2.continent from t1,t2 where T1.id=T2.recid
update T1 set T1.country=T2.country,T1.continent=T2.continent from T1,T2 where T1.id=T2.recid
update T1 set T1.country=T2.country,T1.continent=T2.continent
FROM T1 ,T2
where T1.id=T2.recid