1 2 3 4 5
|
SELECT Incident.NumIncident, Incident.Typologie, Incident.NumSite, Incident.DatIncident, Incident.NomRedacteur, Incident.TypIncident, Incident.MatIncident, Incident.EquipIncident, Incident.DatAnalyseNational, Incident.ResponsableAnalyse, Incident.OuvertLe, Incident.ClosLe, Incident.ClosPar, Incident.CompteRendu, Incident.MesuresSecurisationIntermédiaires, Incident.DateAnalyse, Incident.ResultatAnalyse, Incident.ChefDeProjetRegional, Incident.ChefDeProjetNational, Incident.Statut FROM Incident where Incident.NumIncident in ( SELECT Incident.NumIncident FROM ((((Ville INNER JOIN (Site INNER JOIN Incident ON Site.Site=Incident.NumSite) ON Ville.Ville=Site.Ville) INNER JOIN ReqEstAnalyse ON Incident.NumIncident=ReqEstAnalyse.NumIncident) INNER JOIN ReqEstVisible ON Incident.NumIncident=ReqEstVisible.NumIncident) INNER JOIN ReqEstTraiteNationalement ON Incident.NumIncident=ReqEstTraiteNationalement.NumIncident) INNER JOIN ReqEstClos ON Incident.NumIncident=ReqEstClos.NumIncident WHERE Incident.Statut Like "*" OR
DER BY Incident.NumIncident ) ; |
Partager