1 2 3 4 5
|
SELECT Demandes.ID_Demande, Demandes.Date_Creation, Techniciens.Nom_Tech, Clients.Nom_Client, Pieces.Id_Piece, InfosSystm.nom_Systm, Demandes.Desc_Prob, Last(HeuresDemandes.DateHeureReparation) AS DernierDeDateHeureReparation, Sum(HeuresDemandes.Durée) AS SommeDeDurée, Demandes.DescriptionRep, Desc_Prob.Qte8, Desc_Prob.Desc8, Desc_Prob.Piece8, Desc_Prob.Qte7, Desc_Prob.Desc7, Desc_Prob.Piece7, Desc_Prob.Qte6, Desc_Prob.Desc6, Desc_Prob.Piece6, Desc_Prob.Qte5, Desc_Prob.Desc5, Desc_Prob.Piece5, Desc_Prob.Qte4, Desc_Prob.Desc4, Desc_Prob.Piece4, Desc_Prob.Qte3, Desc_Prob.Desc3, Desc_Prob.Piece3, Desc_Prob.Qte2, Desc_Prob.Desc2, Desc_Prob.Piece2, Desc_Prob.Qte1, Desc_Prob.Desc1, Desc_Prob.Piece1
FROM ((Techniciens INNER JOIN (Pieces INNER JOIN (InfosSystm INNER JOIN (Clients INNER JOIN Demandes ON Clients.[ID_Client] = Demandes.[ID_Client]) ON InfosSystm.[Id_Systm] = Demandes.[Id_Systm]) ON Pieces.[Id_Piece] = Demandes.[ID_Piece]) ON Techniciens.[ID_Tech] = Demandes.[ID_Tech]) INNER JOIN HeuresDemandes ON Demandes.[ID_Demande] = HeuresDemandes.[ID_Demande]) INNER JOIN Desc_Prob ON Demandes.[ID_Demande] = Desc_Prob.[ID_Demande]
GROUP BY Demandes.ID_Demande, Demandes.Date_Creation, Techniciens.Nom_Tech, Clients.Nom_Client, Pieces.Id_Piece, InfosSystm.nom_Systm, Demandes.Desc_Prob, Demandes.DescriptionRep, Desc_Prob.Qte8, Desc_Prob.Desc8, Desc_Prob.Piece8, Desc_Prob.Qte7, Desc_Prob.Desc7, Desc_Prob.Piece7, Desc_Prob.Qte6, Desc_Prob.Desc6, Desc_Prob.Piece6, Desc_Prob.Qte5, Desc_Prob.Desc5, Desc_Prob.Piece5, Desc_Prob.Qte4, Desc_Prob.Desc4, Desc_Prob.Piece4, Desc_Prob.Qte3, Desc_Prob.Desc3, Desc_Prob.Piece3, Desc_Prob.Qte2, Desc_Prob.Desc2, Desc_Prob.Piece2, Desc_Prob.Qte1, Desc_Prob.Desc1, Desc_Prob.Piece1; |
Partager