update
a
set
a = b.a
,b=b.b
,c=b.c
from
t a,t b
where
(a.条件1)
and
(b.条件2)
本文共 122 字,大约阅读时间需要 1 分钟。
update
a
set
a = b.a
,b=b.b
,c=b.c
from
t a,t b
where
(a.条件1)
and
(b.条件2)
转载于:https://www.cnblogs.com/maowh/p/3529253.html