comment ajouter le having
Salut;
j'ai une erreur dans ma req au niveau having
Code:
1 2 3 4 5 6
| SELECT NUM_INSCRIPTION, [11] AS '11', [12] AS '12', [13] AS '13'
FROM (SELECT ETUDIANT.NUM_INSCRIPTION, CAPITALISE_MODULE.NOTE_MODULE, CAPITALISE_MODULE.CODE_MODULE
FROM CAPITALISE_MODULE INNER JOIN
ETUDIANT ON CAPITALISE_MODULE.NUM_INSCRIPTION = ETUDIANT.NUM_INSCRIPTION
WHERE CODE_MODULE IN ('11', '12', '13') AND CODE_TYPE_RELATION_MODULE = 1) having (count(*) =3 group by NUM_INSCRIPTION)P PIVOT (sum(NOTE_MODULE) FOR CODE_MODULE IN ([11],
[12], [13])) AS PV1 |
merci de me corriger