select a.*,b.价税合计金额,b.税额(select 所属机构,项目名称,year(开piao日期) as 年,sum(开piao金额) as 开piao金额 from 开piao申请 group by 所属机构,项目名称,year(开piao日期) ) as a inner join(select 所属机构,项目名称,year(收到日期) as 年,sum(价税合计金额) as 价税合计金额,sum(税额) as 税额 from 进项piao录入 group by 所属机构,项目名称,year(收到日期)) as b on a.所属机构=b.所属机构 and a.项目名称=b.项目名称 and a.年=b.年
|