急急急，寻找高手帮助。。。。。

aslxt

偶然是你 发表于 2013-5-24 16:00
谢谢，但查找不全面，发票当月有发生额但是当月申报为空值不能查找出来，如何查找出客户发票分月汇总SE>申 ...

修改查询3的sql语法为：
SELECT A.NSRSBH, A.月度, [A].[SE之总计]-[B].[SE之总计] AS 发票大于申报
FROM (SELECT 发票.NSRSBH, Format([KPRQ_Q],"yyyymm") AS 月度, Sum(发票.SE) AS SE之总计 FROM 发票 GROUP BY 发票.NSRSBH, Format([KPRQ_Q],"yyyymm"))  AS A LEFT JOIN (SELECT 申报.NSRSBH, Format([SSSQ_Q],"yyyymm") AS 月度, Sum(申报.SE) AS SE之总计 FROM 申报 GROUP BY 申报.NSRSBH, Format([SSSQ_Q],"yyyymm"))  AS B ON (A.NSRSBH = B.NSRSBH) AND (A.月度 = B.月度)
WHERE ((([A].[SE之总计]-[B].[SE之总计])>0))

aslxt

偶然是你 发表于 2013-5-27 09:15
谢谢，aslxt 的的查询只能查当月发票开具当月有申报的业户查询，如果当月开发票但当月没申报即为空值业户 ...

你的表中没有44120219631111033，如何查询出来？

aslxt

问题1（修改了：没有申报的也显示）：
SELECT A.NSRSBH, A.月度, [A].[SE之总计]-nz([B].[SE之总计],0) AS 发票大于申报
FROM (SELECT 发票.NSRSBH, Format([KPRQ_Q],"yyyymm") AS 月度, Sum(发票.SE) AS SE之总计 FROM 发票 GROUP BY 发票.NSRSBH, Format([KPRQ_Q],"yyyymm"))  AS A LEFT JOIN (SELECT 申报.NSRSBH, Format([SSSQ_Q],"yyyymm") AS 月度, Sum(申报.SE) AS SE之总计 FROM 申报 GROUP BY 申报.NSRSBH, Format([SSSQ_Q],"yyyymm"))  AS B ON (A.月度 = B.月度) AND (A.NSRSBH = B.NSRSBH);

aslxt

修改