sql文搞不定了.好象是group by的问题.大家帮我看看.
SELECT SUB_RESULT.KJ_KATUDKOM , SUB_RESULT.KB_JITASYA , SUB_RESULT. NUM ,SUM(SUB_RESULT.CD_OKYAKU)
FROM
(
SELECT
A.KJ_KATUDKOM KJ_KATUDKOM ,C.KB_JITASYA KB_JITASYA ,A.CD_OKYAKU CD_OKYAKU
,MIN(A.CD_ACTITEM) CD_ACTITEM_MIN ,D.SU_HYOJIJUN SU_HYOJIJUN
,COUNT(1) NUM
FROM TBTA020G A ,TBTA021G B
,TBTW001G C
,TBTA001M D
WHERE A.CD_KAISYA = B.CD_KAISYA
AND A.CD_KAISYA = C.CD_KAISYA
AND A.CD_KAISYA = D.CD_KAISYA
AND A.CD_BDHANTEN = B.CD_BDHANTEN AND A.CD_BDHANTEN = D.CD_BDHANTEN AND A.CD_OKYAKU = C.CD_OKYAKU AND A.CD_ACTITEM = B.CD_ACTITEM
AND A.CD_KIKKAKE = D.CD_KIKKAKE
AND A.CD_KAISYA = :cdKaisya
AND A.MJ_SAKUJYO = :mjSakujyo
AND A.CD_BDHANTEN = :cdBdhanten
AND B.DD_KATUDOYM = :ddKatudoym AND B.CD_KATUDSYI = :cdKatudsyi AND B.MJ_KURIK = :mjKurik AND B.MJ_LTERMFOL = :mjLtermfol AND B.MJ_SYONIN = :mjSyonin AND B.MJ_SAKUJYO = :mjSakujyo AND C.MJ_SAKUJYO = :mjSakujyo
AND D.MJ_SAKUJYO = :mjSakujyo
GROUP BY A.KJ_KATUDKOM
,A.CD_OKYAKU
,C.KB_JITASYA ,D.SU_HYOJIJUN
) SUB_RESULT
GROUP BY SUB_RESULT.KJ_KATUDKOM
, SUB_RESULT.KB_JITASYA ORDER BY SUB_RESULT.SU_HYOJIJUN
,SUB_RESULT.CD_ACTITEM_MIN
上面的sql问总报ORA-00979错误.不知道如何解决.不知道我的sql文错在什么地方?GROUP BY 可以在子查询中用一次后,外部父查询再用一次吗?
请大家帮忙看看,谢谢.