1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
| SELECT fd.fdip_abreviation AS Abreviation_formation,
i.c_civilite AS Civilite,
i.nom_patronymique AS Nom,
i.prenom AS Prenom,
EXTRACT(YEAR FROM i.d_naissance) AS Annee_naissance,
p.l_nationalite AS Nationalite,
b.bac_code AS Code_BAC,
b.bac_libelle AS Libelle_BAC,
d.tdipl_code AS Code_dernier_diplome,
d.tdipl_libelle AS Type_dernier_diplome,
h.hist_libelle_der_dipl AS Libelle_dernier_diplome
FROM grhum.individu_ulr i, grhum.pays p, grhum.bac b, garnuche.type_diplome d, grhum.etudiant e, garnuche.historique h, scolarite.scol_formation_specialisation s, scolarite.scol_formation_diplome fd, garnuche.insc_dipl id
WHERE p.c_pays = i.c_pays_nationalite
AND e.no_individu = i.no_individu
AND b.bac_code = e.bac_code
AND h.hist_annee_scol = 2013
AND d.tdipl_code = h.tdipl_code_der_dipl
AND id.hist_numero = h.hist_numero
AND fd.fdip_code = s.fdip_code
AND s.fspn_key = id.dspe_code
AND h.etud_numero = e.etud_numero
ORDER BY fd.fdip_abreviation, i.nom_patronymique, i.prenom |
Partager