1 2 3 4 5 6 7 8 9 10 11 12
| SELECT O.NOM & ' ' & O.PNOM AS OPERATEUR,
F.NOMF & ' ' & F.PNOMF AS FORMATEUR, T.JOUR, T.SITE,
IIf(T.TYPE='True','Chasse','Autre') AS Type, T.TITRE,
IIf(T.TYPE='True',T.RISQUES,'') AS RISQUES,
IIf(T.TYPE='True',T.PREVENTIONS,'') AS PREVENTIONS,
IIf(T.TYPE='False',T.SCORE,'') AS SCORE, T.TOTAL,
IIf(T.LIVRET='True','Oui','Non') AS LIVRET,
IIf(T.FILM='True','Oui','Non') AS FILM
FROM FORMATEUR AS F, OPERATEUR AS O, TEST AS T
WHERE T.OID=O.OID
And T.FID=F.FID
And O.NOM & ' ' & O.PNOM Like '*a*' ; |
Partager