34,590
社区成员
发帖
与我相关
我的任务
分享
update a
set a2 = isnull(b.b2 ,a2)
from a
left join b on a.a1 = b.bq
update a
set a2=b2
from
a,b
where
a.a1=b.b1
update a
set a1=b2
from
a,b
where
a.a1=b.b1
update a
set a1 = b.b2
from a
left join b on a.a1 = b.bq
update b
set b2 = a.a1
from b
left join a on a.a1 = b.bq
update b
set b2 = a.a1
from b
left join a on a.a1 = b.bq