22,209
社区成员
发帖
与我相关
我的任务
分享
update B
set B.b=A.a from A,B where A.useid=B.useid
UPDATE B SET B.B=A.A FROM A WHERE A.USERID=B.USERID
修改下update
b
set
b.b=a.a
from
a,b
where
a.userid=b.userid
update b set
b.b=a.a
from a
where a.userid=b.userid
UPDATE A SET A.A=B.B FROM B WHERE A.USERID=B.USERID