6eme
SELECT b.Nom as Nom, b.Prénom as Prénom FROM etudeserea a, adherents b WHERE a.IDEleve=b.ID and a.annee = 0 and a.Niveau = '6eme' and a.Section= ''
5eme
SELECT b.Nom as Nom, b.Prénom as Prénom FROM etudeserea a, adherents b WHERE a.IDEleve=b.ID and a.annee = 0 and a.Niveau = '5eme' and a.Section= ''
4eme
SELECT b.Nom as Nom, b.Prénom as Prénom FROM etudeserea a, adherents b WHERE a.IDEleve=b.ID and a.annee = 0 and a.Niveau = '4eme' and a.Section= ''
3eme
SELECT b.Nom as Nom, b.Prénom as Prénom FROM etudeserea a, adherents b WHERE a.IDEleve=b.ID and a.annee = 0 and a.Niveau = '3eme' and a.Section= ''
Seconde
SELECT b.Nom as Nom, b.Prénom as Prénom FROM etudeserea a, adherents b WHERE a.IDEleve=b.ID and a.annee = 0 and a.Niveau = 'Seconde' and a.Section= ''
Première
SELECT b.Nom as Nom, b.Prénom as Prénom FROM etudeserea a, adherents b WHERE a.IDEleve=b.ID and a.annee = 0 and a.Niveau = 'Premiere' and a.Section= ''
Terminale
SELECT b.Nom as Nom, b.Prénom as Prénom FROM etudeserea a, adherents b WHERE a.IDEleve=b.ID and a.annee = 0 and a.Niveau = 'Terminale' and a.Section= ''
BTS 1eme Année
SELECT b.Nom as Nom, b.Prénom as Prénom FROM etudeserea a, adherents b WHERE a.IDEleve=b.ID and a.annee = 0 and a.Niveau = 'Terminale' and a.Section= ''
BTS 2eme Année
SELECT b.Nom as Nom, b.Prénom as Prénom FROM etudeserea a, adherents b WHERE a.IDEleve=b.ID and a.annee = 0 and a.Niveau = 'Terminale' and a.Section= ''