SELECT Nom, Id FROM Individu WHERE niveau='1' AND Id IN (SELECT Categorie_No FROM Individu WHERE Repertoire_No=#Repertoire_No#) ORDER BY Nom SELECT Nom, Prenom, Fonction, Id, Categorie_No FROM Individu WHERE niveau='2' and Repertoire_No=#Repertoire_No# ORDER BY Categorie_No, Nom

Team

#Nom#

#Prenom# #Nom#
#Fonction#