1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
|
SELECT
Consigne.Equipement AS Equipement,
Consigne.Batiment AS Batiment,
Horaire.ProgrammeHoraireLundi AS HoraireLundi,
Horaire.ProgrammeHoraireMardi AS HoraireMardi,
Horaire.ProgrammeHoraireMercredi AS HoraireMercredi,
Horaire.ProgrammeHoraireJeudi AS HoraireJeudi,
Horaire.ProgrammeHoraireVendredi AS HoraireVendredi,
Horaire.ProgrammeHoraireSamedi AS HoraireSamedi,
Horaire.ProgrammeHoraireDimanche AS HoraireDimanche,
Horaire.ConsigneETE AS ConsigneETE,
Horaire.ConsigneHiver AS ConsigneHiver,
Horaire.ModeCTA AS ModeCTA
FROM Horaire H1
INNER JOIN Consigne CO
ON CO.IDConsigne = H1.IDConsigne
WHERE CO.Batiment = {ParamBatiment}
AND NOT EXISTS
(SELECT 1
FROM Horaire H2
WHERE H2.IDConsigne = H1.IDConsigne
AND H2.DateHeureModification > H1.DateHeureModification) |
Partager