1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41
| SELECT
R_Arret_Taches.ID_Arrets AS R_Arret_Taches_ID_Arrets,
R_Arret_Taches.T_Arrets_ID_Installations,
R_Arret_Taches.Type, R_Arret_Taches.[Date début],
R_Arret_Taches.[Heure début], R_Arret_Taches.[Date fin],
R_Arret_Taches.[Heure fin], R_Arret_Taches.Particularité,
R_Arret_Taches.[Date de modification], R_Arret_Taches.T_Arrets.Archivé,
R_Arret_Taches.ID_Taches AS R_Arret_Taches_ID_Taches,
R_Arret_Taches.T_Taches_ID_Installations,
R_Arret_Taches.Tâche,
R_Arret_Taches.[Ordre initial] AS OrdreInit,
R_Arret_Taches.[Avant arrêt] AS Avant, R_Arret_Taches.[Après arrêt] AS Apres,
R_Arret_Taches.Métier, R_Arret_Taches.Fournisseur, R_Arret_Taches.Procédure,
R_Arret_Taches.Protocole,
R_Arret_Taches.Périodique, R_Arret_Taches.Périodicité,
R_Arret_Taches.Durée,
R_Arret_Taches.T_Taches.Archivé,
T_Activites.ID_Activites,
T_Activites.ID_Installations,
T_Activites.ID_Arrets, T_Activites.ID_Taches,
T_Activites.[Ordre prévu],
T_Activites.Prévu,
T_Activites.Réalisé,
T_Activites.[Intervenant 1] AS Inter1,
T_Activites.[Intervenant 2] AS Inter2,
T_Activites.[Intervenant 3] AS Inter3,
T_Activites.Remarque,
R_Arret_Taches.Zone,
T_Activites.Débriefing,
R_Arret_Taches.[Date intermédiaire] AS DateInter,
R_Arret_Taches.[Activités intermédiaire] AS ActInter,
R_Arret_Taches.[Zone installation] AS ZoneInst,
R_Taches_Last_Activite.Dernière_exécution
FROM (R_Arret_Taches
LEFT JOIN T_Activites ON (R_Arret_Taches.ID_Taches = T_Activites.ID_Taches)
AND (R_Arret_Taches.ID_Arrets = T_Activites.ID_Arrets))
INNER JOIN R_Taches_Last_Activite ON R_Arret_Taches.ID_Taches = R_Taches_Last_Activite.T_Taches.ID_Taches
WHERE (((R_Arret_Taches.T_Taches.Archivé)=False)); |
Partager