SQL 求和语句简化

[qhlf78]

我的语句如下 （金额结果数据只是测试用,所以有明显错误）
‘首先根据条件查出需要统计的记录
SQL1 = "Select 账套,供货商,含税金额,购进金额 from 表1 where .....



汇总
SQL2 = "Select sum(A.含税金额) as hsje from(" & SQL1 & ") as A where A.账套=E.账套 and A.供货商=E.供货商"
SQL3 = "Select sum(B.购进金额) as gjje from(" & SQL1 & ") as A where A.账套=E.账套 and A.供货商=E.供货商"
SQL = "Select distinct E.账套,E.供货商,(" & SQL2 & ") AS 含税金额,(" & SQL3 & ") AS 购进金额 from(" & SQL1 & ") as E"

结果





感觉 写的臃肿了,该如何改进？

[致命的西瓜]

select distinct E.账套,E.供货商, sum(A.含税金额) as hsje,sum(B.购进金额) as gjje    from SQL 
left join SQL2 ON  A.账套=E.账套 and A.供货商=E.供货商"

简单的关联，这个是大概思路

[qhlf78]

引用 1 楼 wangjian0228 的回复:

select distinct E.账套,E.供货商, sum(A.含税金额) as hsje,sum(B.购进金额) as gjje    from SQL 
left join SQL2 ON  A.账套=E.账套 and A.供货商=E.供货商"

简单的关联，这个是大概思路

你的SQL 和sql2 分别是？

[xiongshao1943]

select 账套,供货商,sum(含税金额),sum(购进金额)
from table1
group by 账套,供货商

其实就是按帐套及供货商来统计含税金额跟购进金额嘛。其实不用请用语句呈现 你把需求说出来更好写语句，而看你的语句有时候会被你带入误区啊

[qhlf78]

引用 3 楼 xiongshao1943 的回复:

select 账套,供货商,sum(含税金额),sum(购进金额)
from table1
group by 账套,供货商

其实就是按帐套及供货商来统计含税金额跟购进金额嘛。其实不用请用语句呈现 你把需求说出来更好写语句，而看你的语句有时候会被你带入误区啊

这么简单啊 谢谢！

[qhlf78]

谢谢大家，已解决