错误“您试图执行不包含指定表达式“ CompanyName”作为聚合函数一部分的查询”
使用聚合函数要求您按SELECT列表中除聚合列以外的列进行分组。
我认为这是您要寻找的:
SELECT
qb1.CompanyName,
qb1.AssetName,
qb1.Year,
qb3.MPPOilRevised - TotalDataPointValue - TotalDataPointValueFactor
FROM
((
SELECT
qb1.CompanyName,
qb1.AssetName,
qb1.Year,
SUM(qb1.DatapointValue) 'TotalDataPointValue',
SUM(qb2.DatapointValue * 1000000) 'TotalDataPointValueFactor'
FROM
(PEBaseQuery AS qb1
INNER JOIN PEBaseQuery AS qb2
ON qb1.Year = qb2.Year AND qb1.AssetName = qb2.AssetName)
WHERE
qb1.DatapointID in (2033, 2035, 2043, 2037, 2031)
AND qb2.DatapointID = 2003
GROUP BY qb1.CompanyName, qb1.AssetName, qb1.Year
) qb1
INNER JOIN PE_MPPOilRevised AS qb3
ON qb1.Year = qb3.Year AND qb1.AssetName=qb3.AssetName)