select [A(1)]=(select sum(A_sum) from A),
[B(2)]=(select sum(B_sum) from B),
[C(3)]=(select sum(C_sum) from C),
[D(4)]=(select sum(D_sum) from D),
运算结果=(select sum(A_sum) from A)-(select sum(B_sum) from B)-(select sum(C_sum) from C)-(select sum(D_sum) from D)
[B(2)]=(select sum(B_sum) from B),
[C(3)]=(select sum(C_sum) from C),
[D(4)]=(select sum(D_sum) from D),
运算结果=(select sum(A_sum) from A)-(select sum(B_sum) from B)-(select sum(C_sum) from C)-(select sum(D_sum) from D)
-(select isnull(sum([sum]),0) from B)
-(select isnull(sum([sum]),0) from C)
-(select isnull(sum([sum]),0) from D)
(select (select sum(sum) from A) as [A(1)],
(select sum(sum) from B) as [B(2)],
(select sum(sum) from C) as [C(3)],
(select sum(sum) from D) as [D(4)])E