日期:2014-05-17 浏览次数:20491 次
update t1 set t1.A=t2.C from TB1 t1 inner join TB2 t2 on t1.ID=t2.ID
update A set A.C=B.A from TB2 A, TB1 B WHERE A.ID=B.ID
update a set a.A=b.C from TAB1 a inner join TAB2 b on a.ID=b.ID