1 2 3 4 5 6
| 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 etablissements AS E ON ???
INNER JOIN membres AS Adm ON ???
WHERE I.Id=1 AND M.CTPN='312' AND M.Lettre_CTPN='B' AND E.CTPN='312' AND Adm.Titre=10 |
Partager