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
| SELECT
dbo_TerminalRepair.RepairID, dbo_TerminalRepair.SNPN, dbo_TerminalTreat.ProblemFound, dbo_TerminalTreat.RemarkTreat, dbo_Terminal.TerminalTypeID, dbo_Terminal.PartnerID, dbo_DefectRow.WarrantyEnd, dbo_DefectRow.WarrantyOK,
dbo_DefectRow.WarrantyEposEnd, dbo_DefectRow.WarrantyEposOK, dbo_DefectRow.DefectRowID
FROM
((dbo_TerminalTreat
INNER JOIN (dbo_TerminalRepair
INNER JOIN dbo_Terminal
ON dbo_TerminalRepair.SNPN = dbo_Terminal.SNPN)
ON dbo_TerminalTreat.RepairID = dbo_TerminalRepair.RepairID)
INNER JOIN dbo_DefectRow
ON dbo_TerminalTreat.RepairID = dbo_DefectRow.RepairID)
INNER JOIN (Select LastDefectRowID From (SELECT Max(dbo_DefectRow.DefectRowID) AS LastDefectRowID, dbo_DefectRow.RepairID FROM dbo_DefectRow GROUP BY dbo_DefectRow.RepairID)) AS sq_DefectRowIDGroupByRepairID
ON sq_DefectRowIDGroupByRepairID.LastDefectRowID = dbo_DefectRow.DefectRowID
WHERE
(
(
dbo_TerminalRepair.RepairID In
(
Select RepairID From
(
SELECT dbo_TerminalRepairStock.RepairID, TypeStock
FROM dbo_TerminalRepairStock,
(
SELECT dbo_TerminalRepairStock.RepairID, Max(dbo_TerminalRepairStock.DateIN) As MaxDateIn
FROM dbo_TerminalRepairStock
GROUP BY dbo_TerminalRepairStock.RepairID
) AS LastStock
WHERE
(
(dbo_TerminalRepairStock.RepairID=LastStock.RepairID) AND
(LastStock.MaxDateIn=dbo_TerminalRepairStock.DateIN)
)
) AS Q_SelectLastTerminalStock WHERE TypeStock = 'Defective'
)
)
); |
Partager