求一句sql语句！急（再线等）！

[milerzhang]

我要用一句SQL语句，算出四个总和值：sum(jfje),sum(dfje),sum(bjfje),sum(bdfje)！这条SQL语句要用到两个表，TB_CW和SYSCWKM,其中TB_CW的KMDM要等于SYSCWKM的KMDM，并且sum(jfje)和sum(dfje)是在日期2003.7.15之前的，sum(bjfje)和sum(bdfje)是在日期2003.10.15之前的!sum(jfje),sum(dfje),sum(bjfje),sum(bdfje)所需要计算的数据都在表TB_CW里，日期也在表TB_CW里!
各位大人帮帮忙!小弟在此谢谢了!

[银狐被占用]

select jfje=sum(select jfje from tb_cw where 日期>'2003-7-15'),
dfje=sum(select dfje from tb_cw where 日期>'2003-7-15'),
bjfje=sum(select bjfje from tb_cw where 日期>'2003-10-15'),
bdfje=sum(select bdfje from tb_cw where 日期>'2003-10-15')
from tb_cw
join syscwkm on tb_cw.kmdm=syscwkm.kmdm

[txlicenhe]

select sum( case when 日期< '2003-7-15' then jfje else 0 end) as jfje,
sum( case when 日期< '2003-7-15' then dfje else 0 end) as dfje,
sum( case when 日期< '2003-10-15' then bjfje else 0 end) as bjfje,
sum( case when 日期< '2003-10-15' then bdfje else 0 end) as bdfje
from tb_cw
join syscwkm on tb_cw.kmdm=syscwkm.kmdm

[zjcxc]

select sum(case when a.日期<'2003-07-15' then a.jfje end)
,sum(case when a.日期<'2003-07-15' then a.dfje end)
,sum(case when a.日期<'2003-10-15' then a.bjfje end)
,sum(case when a.日期<'2003-10-15' then a.bdfje end)
from TB_CW a inner join SYSCWKM b on a.KMDM=b.KMDM

[flymoods]

select sum( case when 日期< '2003-7-15' then jfje else 0 end) as jfje,
sum( case when 日期< '2003-7-15' then dfje else 0 end) as dfje,
sum( case when 日期< '2003-10-15' then bjfje else 0 end) as bjfje,
sum( case when 日期< '2003-10-15' then bdfje else 0 end) as bdfje
from tb_cw
inner join syscwkm on tb_cw.kmdm=syscwkm.kmdm

[zjcxc]

--或者:
select jfje,dfje,bjfje,bdfje
from(
select id=1,jfje=sum(a.jfje),dfje=sum(a.dfje)
from TB_CW a inner join SYSCWKM b on a.KMDM=b.KMDM
where a.日期<'2003-07-15
) a join (
select id=1,bjfje=sum(a.bjfje),bdfje=sum(a.bdfje)
from TB_CW a inner join SYSCWKM b on a.KMDM=b.KMDM
where a.日期<'2003-10-15
) b on a.id=b.id

[zjcxc]

第二种方法应该效率高一些.

[lvltt]

select sum( case when 日期< '2003-7-15' then jfje else 0 end) as jfje,
sum( case when 日期< '2003-7-15' then dfje else 0 end) as dfje,
sum( case when 日期< '2003-10-15' then bjfje else 0 end) as bjfje,
sum( case when 日期< '2003-10-15' then bdfje else 0 end) as bdfje
from tb_cw
join syscwkm on tb_cw.kmdm=syscwkm.kmdm

[milerzhang]

我是用commandtext来传SQL语句的！可有限定长度！各位大侠知道要怎么设置才可以增加长度吗？