select abb06, aag02,afc06, afc07 as 已消耗预算,afb11, sum(decode(abb06,1,abb07,2,abb07*-1)) , sum(afc07-abb07) ,afb03 ,afc05 ,afb04 ,afb02
from afc_file,abb_file,afb_file,aba_file,aag_file
where --aba06 <> 'CE' --不等于CE
abb03=AFB02
and afb03=aba03 --年份对应
and afc03=afb03 --年份
and afc02=afb02 --科目
and afb02=aag01 --科目
and aba04=afc05 -- 月份对应
and afb04=abb05 --部门对应
and afc04=afb04 --部门
and abb01=aba01 --凭证号
and afb03='2017'
and abb05='SH0000'
and abb03='660227'
group by afc07,afc07-abb07,afb03,afc05,afb04,afb02,aag02,afc06,afb11,abb06,decode(abb06,1,abb07,2,abb07*-1)
order by afc07-abb07
要把每个月份的求和,但是没有求和