|
select 一级科目,二级科目,三级科目,sum([本期发生额(借方)]) as 累计发生额 from
(select a.一级科目,b.二级科目,a.三级科目,a.[本期发生额(借方)]
from
(select "营业费用" as 一级科目,mid(科目代码,5,2) as 二级科目代码,科目名称 as 三级科目,[本期发生额(借方)]
from [费用明细$] where 科目代码 like '%-%')a
inner join
(select mid(科目代码,5,2) as 二级科目代码,科目名称 as 二级科目 from [费用明细$] where 科目代码 NOT like '%-%')b
on a.二级科目代码=b.二级科目代码)
group by 一级科目,二级科目,三级科目
union all
select "总计" as 一级科目,"" as 二级科目,"" as 三级科目,sum ([本期发生额(借方)]) as 累计发生额 from
(select a.一级科目,b.二级科目,a.三级科目,a.[本期发生额(借方)]
from
(select "营业费用" as 一级科目,mid(科目代码,5,2) as 二级科目代码,科目名称 as 三级科目,[本期发生额(借方)]
from [费用明细$] where 科目代码 like '%-%')a
inner join
(select mid(科目代码,5,2) as 二级科目代码,科目名称 as 二级科目 from [费用明细$] where 科目代码 NOT like '%-%')b
on a.二级科目代码=b.二级科目代码) |
|