27,582
社区成员




Update [TableB]
set a.a17 = b.a17,a.a18 = b.a18,a.a19 = b.a19,a.a20 = b.a20
from [TableB] a inner join [TableC] b on a.a1 = b.a1 and a.a4 = b.a4 and a.a7 = b.a7 and a.a11 = b.a11 and b.AID = 1
Update a
set a.a17 = b.a17,a.a18 = b.a18,a.a19 = b.a19,a.a20 = b.a20
from [TableB] a inner join [TableC] b
on a.a1 = b.a1 and a.a4 = b.a4 and a.a7 = b.a7 and a.a11 = b.a11 and b.AID = 1
Update [TableB]
set a.a17 = b.a17,a.a18 = b.a18,a.a19 = b.a19,a.a20 = b.a20
from [TableB] a inner join [TableC] b
on a.a1 = b.a1 and a.a4 = b.a4 and a.a7 = b.a7 and a.a11 = b.a11 and b.AID = 1 set a.a17 = b.a17,a.a18 = b.a18 and a.a19 = b.a19 and a.a20 = b.a20
Update a
set a.a17 = b.a17,a.a18 = b.a18,a.a19 = b.a19,a.a20 = b.a20
from
[TableB] a
inner join [TableC] b on a.a1 = b.a1 and a.a4 = b.a4 and a.a7 = b.a7 and a.a11 = b.a11 and b.AID = 1