27,580
社区成员
发帖
与我相关
我的任务
分享
update a
set b1 = b.b2,
c1 = b.c2,
d1 = b.d2
from a inner join b on a.a1 = b.a2
update a
set b1 = b.b2,
c1 = b.c2,
d1 = b.d2
from a,b where a.a1 = b.a2
update a
set b1 = b.b2,
c1 = b.c2,
d1 = b.d2
from a , b where a.a1 = b.a2
update a
set b1 = b.b2,
c1 = b.c2,
d1 = b.d2
from a inner join b on a.a1 = b.a2
--现在有表A A1 B1 C1 D1 表B A2 B2 C2 D2
UPDATE A SET B1=B.B2,C1=B.C2,D1=B.D2
FROM B
WHERE A.A1=B.A2
update A
set A.B1=B.B2,A.C1=B.C2,A.D1=B.D2
where A.A1=B.A2