select
[hm] as 户名,
df AS 电费,
dl AS 电量
from (
SELECT
[userInfo].[hm] ,
[userInfo].[hH],
sum([dTotal].[BYDL]*[userInfo].[DJH]*[userInfo].[DBL] ) AS df,
sum([dTotal].[bydl]*[userInfo].[DBL]) AS dl
FROM dTotal INNER JOIN userInfo ON [dTotal].[hh]=[userInfo].[hh]
WHERE (([dTotal].[cbrq]) Between [汇总起始日期] And [汇总结束日期])
group by [userInfo].[hm] ,[userInfo].[hH]
) as x
[hm] as 户名,
df AS 电费,
dl AS 电量
from (
SELECT
[userInfo].[hm] ,
[userInfo].[hH],
sum([dTotal].[BYDL]*[userInfo].[DJH]*[userInfo].[DBL] ) AS df,
sum([dTotal].[bydl]*[userInfo].[DBL]) AS dl
FROM dTotal INNER JOIN userInfo ON [dTotal].[hh]=[userInfo].[hh]
WHERE (([dTotal].[cbrq]) Between [汇总起始日期] And [汇总结束日期])
group by [userInfo].[hm] ,[userInfo].[hH]
) as x
[userInfo].[hm] as 户名,
sum([dTotal].[BYDL]*[userInfo].[DJH]*[userInfo].[DBL] ) AS 电费,
sum([dTotal].[bydl]*[userInfo].[DBL]) AS 电量
FROM dTotal INNER JOIN userInfo ON [dTotal].[hh]=[userInfo].[hh]
WHERE (([dTotal].[cbrq]) Between [汇总起始日期] And [汇总结束日期])
group by [dTotal].[HH],[userInfo].[hm]