1 2 3
| SELECT signa.nn, signa.lname AS Nom, signa.fname AS Prénom, IIf([sex]=1,"M","F") AS Sexe, signa.lang AS Langue, signa.email AS [E-mail], signa.gsm AS GSM, signa.phone AS Téléphone, signa.Eval AS Evaluation, signa.assim_nbr AS [N° Assim], function.labelf AS Fonction, IIf([period].[ID]=13,"X","") AS [Ete 2018 - P1], IIf([period].[ID]=14,"X","") AS [Ete 2018 - P2], IIf([period].[ID]=15,"X","") AS [Ete 2018 - P3], IIf([period].[ID]=16,"X","") AS [Ete 2018 - P4]
FROM function INNER JOIN (signa INNER JOIN (period INNER JOIN prefs ON period.ID = prefs.periodID) ON signa.ID = prefs.signaID) ON function.ID = prefs.functionID
ORDER BY signa.lname, signa.fname; |
Partager