全连接数据 不能完全出来的问题！请教大神，谢谢！

aslxt

是不是这个:
SELECT tmp.合同编号, Count(tmp.销项发票汇总) AS 销项发票汇总之计算, Sum(tmp.销项发票次数) AS 销项发票次数之总计, Sum(tmp.进项发票汇总) AS 进项发票汇总之总计, Sum(tmp.进项发票次数) AS 进项发票次数之总计
FROM (SELECT Q_销项发票汇总.合同编号, Q_销项发票汇总.销项发票汇总, Q_销项发票汇总.销项发票次数, 0 as 进项发票汇总, 0 as 进项发票次数
FROM Q_销项发票汇总

UNION SELECT 合同编号, 0 as 销项发票汇总, 0 as 销项发票次数, Q_进项发票汇总.进项发票汇总, Q_进项发票汇总.进项发票次数
FROM  Q_进项发票汇总 )  AS tmp
GROUP BY tmp.合同编号;

aslxt

玻璃球 发表于 2021-4-20 22:16
谢谢大神回复，还是看不懂，对代码这种不是很明白

查询的语句啊,就是查询的SQL视图所看到的.