高手来帮下忙SQL语句

[kingtiy]

select acc_nbr,sum(c1), sum(c2), sum(c3) from
(
select acc_nbr,charge c1,0 c2,0 c3
from A
union all
select acc_nbr,0 c1,charge c2,0 c3
from B
union all
select acc_nbr,0 c1,0 c2 ,charge c3
from C
)
group by acc_nbr
A,B,C三个表结构相同,字段如下:
acc_nbr char(10) charge int (10)

[数字化从业者老高]

不错，呵呵！

[kingtiy]

知道了,谢谢大家哟

[Reeezak]

你们这就开工了？
幸福啊～～
太忙了，偷闲上来看看，我也只有看的份了～～

[xeqtr1982]

select acc_nbr,sum(c1), sum(c2), sum(c3) from
(
select acc_nbr,charge c1,0 c2,0 c3
from A
union all
select acc_nbr,0 c1,charge c2,0 c3
from B
union all
select acc_nbr,0 c1,0 c2 ,charge c3
from C
)a
group by acc_nbr
--从结果集中查询要加别名

[LouisXIV]

select acc_nbr,sum(c1), sum(c2), sum(c3) from
(
select acc_nbr,charge c1,0 c2,0 c3
from A
union all
select acc_nbr,0 c1,charge c2,0 c3
from B
union all
select acc_nbr,0 c1,0 c2 ,charge c3
from C
)a--这里，表别名
group by acc_nbr

[liangpei2008]

xeqtr1982回归，答题速度不逊当年！:)

[xeqtr1982]

不行了，明显反应迟钝了...