1 2 3
|
SELECT tblDownTimeReport.DownTimeReportID , tblDownTimeReport.ApplicationTypeNameID , tblDownTimeReport.ResolutionID , tblDownTimeReport.ProblemStarted , tblDownTimeReport.ServiceRestored , tblDownTimeReport.HeatCallId , tblDownTimeReport.ElixCallId , tblDownTimeReport.Description , tblDownTimeReport.ProblemAnalysis , tblDownTimeReport.Prevention , tblDownTimeReport.MethodUsed , tblDownTimeReport.BusinessImpact , tblDownTimeReport.PersonResponsible , tblDownTimeReport.TotalDownTime , tblDownTimeReport.Primm , tblDownTimeReport.CauseID , tblDownTimeReport.StatutID , tblDownTimeReport.FollowUpRequiredID , tblDownTimeReport.Suivi , tblDownTimeReport.Commentaire , tblDownTimeReport.IsValidReport , tblDownTimeReport.CreatorName FROM tblDownTimeReport
left join tblCrossdowntimeSitename on tblCrossdowntimeSitename.DownTimeReportID = tblDownTimeReport.DownTimeReportID left join tblApplicationTypeName on tblApplicationTypeName.ApplicationTypeNameID = tblDowntimeReport.ApplicationTypeNameID WHERE ((tblDownTimeReport.DownTimeReportID > 1 ) AND (tblDownTimeReport.DownTimeReportID < 100 ) ) ORDER BY tblApplicationTypeName.ApplicationName ASC |
Partager