a guest Sep 23rd, 2019 142 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. select as 'idE',
  2.                 eleve.nom as 'nomE',
  3.                 eleve.prenom as 'prenomE',
  4.                 division.libelle as 'divisionE',
  5.                 salle.libelle as 'salleE',
  6.                 discipline.libelle as 'disciplineE',
  7.                 natureepreuve.libelle as 'epreuveE',
  8.        as 'jourE',
  9.                 plage.heureDebut as 'plagHoraireE',
  10.                 epreuve.dureeEpreuve as 'dureeEpreuveE',
  11.                 eleve.tiersTempsON as 'tiersTempsE',
  12.                 passageepreuve.absence as 'absenceE',
  13.        as 'idP',
  14.                 utilisateur.nom as 'nomP',
  15.                 utilisateur.prenom as 'prenomP'
  16.                 from passageepreuve join eleve on
  17.                 join division on
  18.                 join salle on
  19.                 join epreuve on
  20.                 join discipline on
  21.                 join natureepreuve on
  22.                 join plagedemijournee on passageepreuve.idDemiJournee=plagedemijournee.idDemiJournee and passageepreuve.idPlage=plagedemijournee.idPlage
  23.                 join demijournee on
  24.                 join plage on
  25.                 join utilisateur on
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand