sql server 中sum函数里面不能再嵌套sum和子查询怎么解决啊，求大神指点啊，在线等，急急急

[左琴右剑少年时]

SELECT SUM(A.SUM_TO_DATE) AS SUM_TO_DATE,
SUM(A.TOTAL_ACTU_SUM) AS CON_COM,
SUM(ISNULL((SELECT SUM(B.Rqpt_Sum)
FROM HT_RQPT B
INNER JOIN HT_RQMT C
ON B.RQMT_ID = C.RQMT_ID
WHERE C.CNMT_ID = A.CNMT_ID),
0)) AS SUM_RQPT
FROM V_HT_CNMT A
WHERE A.PROJ_ID = '6EB732CA99D046D6BB1DA70EF80EBAEA'
AND A.CONTRACT_TYPE = 'CON'
AND A.EXESTATUS = 'EFFICIENT'





消息 130，级别 15，状态 1，第 7 行
不能对包含聚合或子查询的表达式执行聚合函数。

[中国风]

SELECT  SUM(A.SUM_TO_DATE) AS SUM_TO_DATE
       ,SUM(A.TOTAL_ACTU_SUM) AS CON_COM
       ,ISNULL(SUM(B.Rqpt_Sum) , 0) AS SUM_RQPT
FROM    V_HT_CNMT A
	LEFT JOIN (		SELECT C.CNMT_ID ,SUM(B.Rqpt_Sum) AS Rqpt_Sum
                     FROM   HT_RQPT B
                            INNER JOIN HT_RQMT C ON B.RQMT_ID = C.RQMT_ID
                     GROUP BY   C.CNMT_ID) AS B ON B.CNMT_ID = A.CNMT_ID
WHERE   A.PROJ_ID = '6EB732CA99D046D6BB1DA70EF80EBAEA'
        AND A.CONTRACT_TYPE = 'CON'
        AND A.EXESTATUS = 'EFFICIENT';

[道素]

逻辑上相同A.PROJ_ID,A.CONTRACT_TYPE,A.EXESTATUS中可能包含多个CNMT_ID 改成下面的试试

	SELECT SUM(A.SUM_TO_DATE) AS SUM_TO_DATE,
       SUM(A.TOTAL_ACTU_SUM) AS CON_COM,
       SUM(ISNULL(D.Rqpt_Sum, 0)) AS SUM_RQPT
  FROM V_HT_CNMT A
  LEFT JOIN (
   	  SELECT C.CNMT_ID,SUM(B.Rqpt_Sum) AS Rqpt_Sum FROM HT_RQPT B INNER JOIN HT_RQMT C  ON B.RQMT_ID = C.RQMT_ID  GROUP BY  C.CNMT_ID--  WHERE C.CNMT_ID = A.CNMT_ID
  ) D ON D.CNMT_ID=A.CNMT_ID
 WHERE A.PROJ_ID = '6EB732CA99D046D6BB1DA70EF80EBAEA'
   AND A.CONTRACT_TYPE = 'CON'
   AND A.EXESTATUS = 'EFFICIENT'
	GROUP BY A.PROJ_ID,A.CONTRACT_TYPE,A.EXESTATUS

[tcmakebest]

SUM不能嵌套,但SELECT可以嵌套啊. select sum(...) from ( select sum(...), ..... ) as tt