为什么计算字段HJJC出来的数字为0，急用~~~在线等：）））

[llh6795]

select bh,sum(ydsl) as ydsl,sum(edsl) as edsl,sum(sdsl) as sdsl,sum(dwsl) as dwsl,(sum(ydsl)+sum(edsl)+sum(sdsl)+sum(dwsl)) as hjjc from tjyb group by bh

要出统计报表，HJJC字段出来为0，不知道为什么，请指点，谢谢：）））

[pt1314917]

--不清楚表结构。试试

select bh,sum(ydsl) as ydsl,sum(edsl) as edsl,sum(sdsl) as sdsl,sum(dwsl) as dwsl,
(isnull(sum(ydsl),0)+isnull(sum(edsl),0)+isnull(sum(sdsl),0)+isnull(sum(dwsl),0)) as hjjc  from tjyb group by bh 

[dawugui]

select bh,
       sum(ydsl) as ydsl,
       sum(edsl) as edsl,
       sum(sdsl) as sdsl,
       sum(dwsl) as dwsl,
       sum(ydsl+edsl+sdsl+dwsl) as hjjc  
from tjyb 
group by bh 

[llh6795]

谢谢，除了EDSL，其他字段都有可能为0

[llh6795]

不知道为什么，如果sum(ydsl)+sum(edsl)) as hjjc 有数字显示，多于两个累加就为0

sum(ydsl+edsl+sdsl+dwsl) as hjjc 出来也是0

[llh6795]

谢谢~~~出来了，揭贴了：）））