1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
| SELECT T_AffectationCohorte.SessionAffectation
, T_AffectationCohorte.BlocAffectation
, T_AffectationCohorte.DureeAffectation
, T_Cohorte.NoCohorte
, T_Cours.NomCours
, T_Enseignant.Initiale
, T_Enseignant.Disponibilite
,(T_Enseignant.Disponibilite - T_AffectationCohorte.DureeAffectation) AS TempsDisponibiliteRestant
FROM dbo.T_AffectationCohorte AS AC
INNER JOIN dbo.T_Cohorte AS C
ON AC.FKcohorte = C.PKcohorte
INNER JOIN dbo.T_Cours AS CR
ON AC.FKcours = CR.PKcours
INNER JOIN dbo.T_Enseignant AS E
ON AC.FKenseignant = E.PKenseignant |
