1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39
| SELECT
_etudiant.id_Etudiant AS id_Etudiant,
_etudiant.n_iscp AS n_iscp,
_etudiant.cne AS cne,
_etudiant.nomA AS nomA,
_etudiant.prenomA AS prenomA,
_noteMod0.id_notMod0 AS id_notMod0,
_noteMod0.id_Etudiant AS id_Etudiant__n,
_noteMod0.id_modu AS id_modu,
_noteMod0.id_anu AS id_anu,
_noteMod0.noteMod0 AS noteMod0,
_noteMod0.id_user AS id_user,
_noteMod0.rem AS rem,
_noteMod0.type AS type
FROM
_etudiant,
_noteMod0
WHERE
_noteMod0.id_Etudiant = _etudiant.id_Etudiant
AND
(
_noteMod0.id_modu = ANY
(
SELECT
_module.id_modu AS id_modu,
_module.codM AS codM,
_module.intitul AS intitul,
_module.id_sem AS id_sem,
_module.flag AS flag,
_module.id_cycle AS id_cycle
FROM
_module
WHERE
_module.id_sem = 1
)
AND _noteMod0.id_anu = 11
AND _noteMod0.noteMod0 < 10
AND _noteMod0.type = 'ninsc'
) |
Partager