1 2 3
| SELECT Equipment.Program, Equipment.IDEQUIPMENT, Equipment.EquipmentDescription, Equipment.SubFamily, Equipment.IRP, Equipment.T0, Equipment.FtCv, Equipment.Article, Equipment.TotalQty, Equipment.Frequency, Equipment.Network, Equipment.Supplier, Equipment.[Country], EquipmentBatch.IDEQUIPMENTBATCH, EquipmentBatch.DescriptionBatch, EquipmentBatch.IDMODEL, EquipmentBatch.Qty, ML.IDML, ML.MLType, ML.ContractDate, ML.AdditionalNotes, ML.IncomingDate, ML.OffsetTwUser, ML.PP1W, ML.PP1Day, SBHistory.IDSB, SBHistory.IDNUMBER, SBHistory.SBModificationDate, SBHistory.DateSB, SBHistory.ExplanationSB, NeedHistory.IDNEED, NeedHistory.IDNUMBERNEED, NeedHistory.NeedModificationDate, NeedHistory.DateNeed, NeedHistory.ExplanationNeed, PPHistory.IDPPHISTORY, PPHistory.IDNUMBERPP, PPHistory.PPDate, PPHistory.PPComment, Program.Statut, PDP.FileName
FROM PP INNER JOIN ((NeedHistory INNER JOIN (SBHistory INNER JOIN (PPHistory INNER JOIN ML ON PPHistory.IDPPHISTORY = ML.PDP) ON SBHistory.IDSB = ML.SB) ON NeedHistory.IDNEED = ML.Need) INNER JOIN (((Program INNER JOIN Equipment ON Program.ProgramName = Equipment.Program) INNER JOIN (EquipmentBatch INNER JOIN LinkEqptBatchPPML ON EquipmentBatch.IDEQUIPMENTBATCH = LinkEqptBatchPPML.IDEQUIPMENTBATCH) ON Equipment.IDEQUIPMENT = EquipmentBatch.IDEQUIPMENT) INNER JOIN LinkEquipmentPP ON Equipment.IDEQUIPMENT = LinkEquipmentPP.IDEQUIPMENT) ON ML.IDML = LinkEqptBatchPPML.IDML) ON (PP.IDPP = LinkEqptBatchPPMLS.IDPP) AND (PP.IDPP = LinkEquipmentPP.IDPP)
WHERE (((Program.Statut)="X")); |
Partager