从您在评论中提到的错误：
错误“您试图执行不包含指定表达式“ CompanyName”作为聚合函数一部分的查询”
使用聚合函数要求您按SELECt列表中除聚合列以外的列进行分组。
编辑：
我认为这是您要寻找的：
SELECT qb1.CompanyName, qb1.AssetName, qb1.Year, qb3.MPPOilRevised - TotalDataPointValue - TotalDataPointValueFactorFROM (( 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)
