ERREUR: ORA-00979: n'est pas une expression GROUP BY
Bonjour à tous,
J'ai une erreur lors de l'execution d'un script sur ORACLE:
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
| SELECT TRUNC(A.COD_MOI,'MM') COD_DAT,
A.cod_res,
SUM(A.mtt_det) mtt_det,
B.bol_plc,
SUM(B.mtt_obj_det) mtt_obj_det,
B.lib_typ_bai
FROM EDE_PRD.F_DET_DETTE_MOIS A
INNER JOIN
EDE_PRD.f_obj_det_mer B
ON ( A.cod_moi = B.cod_moi
AND A.cod_res = B.cod_res
AND A.LIB_TYP_BAI = B.LIB_TYP_BAI)
WHERE
A .LIB_TYP_BAI = 'LOGEMENTS' AND
B .LIB_TYP_BAI = 'LOGEMENTS'
AND A.COD_SOC = 'LMH'
AND A.bol_plc = 1
AND B.bol_plc = 1
AND B.COD_TYP_SVI ='Contentieux'
AND A.COD_MOI >= '01/01/2018'
GROUP BY A.COD_RES,TRUNC(A.COD_MOI,'MM') |
Merci