Bonjour,

J'aimerais savoir si pour un INNER JOIN, on peut utiliser 2 ON et si oui comment ?

J'ai cette requête-ci mais le deuxième ON est ignoré (en gras) il ne vérifie pas la lettre :
SELECT I.Civilite,I.Nom As iNom,I.Prenom As iPrenom,I.Email As iEmail,S.Intitule,S.Ddebut,S.Dfin,S.Lieu,S.Ville As sVille,M.Nom As mNom,M.Prenom As mPrenom,M.Email As mEmail,E.Nom As eNom,E.Rue,E.Code_postal,E.Ville As eVille,E.Email As eEmail,Adm.Nom As aNom,Adm.Prenom As aPrenom,Adm.Ville As aVille,Adm.Email AS aEmail FROM inscrits As I INNER JOIN stages AS S ON S.Id=I.Id_stage INNER JOIN membres AS M ON (M.CTPN='312' AND M.Lettre_CTPN='B') INNER JOIN etablissements AS E ON E.CTPN='312' INNER JOIN membres AS Adm ON Adm.Titre=10 WHERE I.Id=1
Merci d'avance