oracle sum里面写条件,[Q]一个SQL的问题：请问SUM的字段是否不能作为ｗｈｅｒｅ中的条件呢？例子如下...

SELECT (SELECT MC FROM DB.DJ_SJ WHERE A.JDM=JDM) AS MC,

(SELECT LXDM FROM DB.DJ_SJ WHERE A.JDM=JDM) AS DH ,

A.ZDM,

(SELECT MMC FROM DM.SB_SM WHERE A.ZDM=MDM) AS ZMC,

A.JDM,

SUM(B.JE) AS ZJE,

SUM(B.RE) AS ZRE,

SUM(B.KL) AS ZKL,

A.FSDM,

A.SJLY

FROM SB.SB_JZ A,

SB.SB_JMX B

WHERE A.XDM='09'

AND SUBSTR(A.ZWBS,1,2)<>'0'

AND A.YRQ>=TO_DATE('2004-04-01','YYYY-MM-DD')

AND A.BRQ>=TO_DATE('2004-04-01','YYYY-MM-DD')

AND A.BRQ<=TO_DATE('2004-04-30 23:59:59','YYYY-MM-DD HH24:MI:SS')

AND A.PZH=B.PZH

AND A.ZDM='12'

GROUP BY A.JDM,A.ZDM,A.FSDM,A.SJLY ORDER BY ZJE DESC

就是运行

但是

SELECT (SELECT MC FROM DB.DJ_SJ WHERE A.JDM=JDM) AS MC,

(SELECT LXDM FROM DB.DJ_SJ WHERE A.JDM=JDM) AS DH ,

A.ZDM,

(SELECT MMC FROM DM.SB_SM WHERE A.ZDM=MDM) AS ZMC,

A.JDM,

SUM(B.JE) AS ZJE,

SUM(B.RE) AS ZRE,

SUM(B.KL) AS ZKL,

A.FSDM,

A.SJLY

FROM SB.SB_JZ A,

SB.SB_JMX B

WHERE A.XDM='09'

AND SUBSTR(A.ZWBS,1,2)<>'0'

AND A.YRQ>=TO_DATE('2004-04-01','YYYY-MM-DD')

AND A.BRQ>=TO_DATE('2004-04-01','YYYY-MM-DD')

AND A.BRQ<=TO_DATE('2004-04-30 23:59:59','YYYY-MM-DD HH24:MI:SS')

AND A.PZH=B.PZH

AND A.ZDM='12'

[B]

AND ZJE>=0

AND ZRE>=0

AND ZKL>=0

[/B]

GROUP BY A.JDM,A.ZDM,A.FSDM,A.SJLY ORDER BY ZJE DESC

就开始乱报错误了非说

ERROR at line 24:

ORA-00904: "ZKL": invalid identifier