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
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
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
,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
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
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
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