SHARE
TWEET

lululululu

a guest Sep 23rd, 2019 142 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. select eleve.id 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.                 demijournee.date as 'jourE',
  9.                 plage.heureDebut as 'plagHoraireE',
  10.                 epreuve.dureeEpreuve as 'dureeEpreuveE',
  11.                 eleve.tiersTempsON as 'tiersTempsE',
  12.                 passageepreuve.absence as 'absenceE',
  13.                 utilisateur.id as 'idP',
  14.                 utilisateur.nom as 'nomP',
  15.                 utilisateur.prenom as 'prenomP'
  16.                 from passageepreuve join eleve on idEleve=eleve.id
  17.                 join division on idDivision=division.id
  18.                 join salle on idSalle=salle.id
  19.                 join epreuve on idEpreuve=epreuve.id
  20.                 join discipline on idDiscipline=discipline.id
  21.                 join natureepreuve on idNatureEpreuve=natureepreuve.id
  22.                 join plagedemijournee on passageepreuve.idDemiJournee=plagedemijournee.idDemiJournee and passageepreuve.idPlage=plagedemijournee.idPlage
  23.                 join demijournee on plagedemijournee.idDemiJournee=demijournee.id
  24.                 join plage on plagedemijournee.idPlage=plage.id
  25.                 join utilisateur on passageepreuve.idProfAffecte=utilisateur.id
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
 
Top