1 2 3 4
| SELECT T_RendezVous.NR, Min(T_RendezVous.DateRdV1) AS DateRdV1, Max(T_RendezVous.NbRecurrences) AS NbRecurrences, T_RendezVous.Recurrence, T_RendezVous.Report, T_RendezVous.ReportNbJ, T_RendezVous.ID_Salles, T_RendezVous.HoraireDebut, T_RendezVous.TypeRdv, T_RendezVous.HoraireFin, T_RendezVous.ID.Value AS ID, T_RendezVous.Memo, T_RendezVous.Professeur, T_RendezVous.Classes, T_RendezVous.CursusType, T_RendezVous.Instrument1, T_RendezVous.Instrument2, T_RendezVous.Instrument3, T_RendezVous.Atelier_NOM, T_RendezVous.Atelier2, T_RendezVous.Atelier3, T_RendezVous.ChxInstru
FROM T_CouleurRdv INNER JOIN (T_RendezVous INNER JOIN T_Salles ON T_RendezVous.ID_Salles = T_Salles.ID_Salles) ON T_CouleurRdv.NCouleur = T_RendezVous.TypeRdv
GROUP BY T_RendezVous.NR, T_RendezVous.Recurrence, T_RendezVous.Report, T_RendezVous.ReportNbJ, T_RendezVous.ID_Salles, T_RendezVous.HoraireDebut, T_RendezVous.TypeRdv, T_RendezVous.HoraireFin, T_RendezVous.ID.Value, T_RendezVous.Memo, T_RendezVous.Professeur, T_RendezVous.Classes, T_RendezVous.CursusType, T_RendezVous.Instrument1, T_RendezVous.Instrument2, T_RendezVous.Instrument3, T_RendezVous.Atelier_NOM, T_RendezVous.Atelier2, T_RendezVous.Atelier3, T_RendezVous.ChxInstru
ORDER BY Min(T_RendezVous.DateRdV1); |
Partager