1 2 3 4 5
| SELECT Facture.ApplicationGroupeApplication, Facture.FamilleService, Facture.Service, Facture.CategorieApplication, Facture.CritereTri, Facture.PrixService,Facture.CoutTotalService,Facture.UOCleRepartitionClient,Facture.NombreTotalUO,facture.PrixUnitaireUO, facture.NombreUOClient,facture.QuotePartClient, facture.ClientNiveau1, facture.ClientNiveau2
FROM Facture
WHERE Facture.periode='2011 Budget' AND Facture.ClientNiveau3 = 'DCFG'
GROUP BY Facture.ApplicationGroupeApplication, Facture.FamilleService, Facture.CritereTri, Facture.Service, Facture.CategorieApplication, Facture.PrixService,Facture.CoutTotalService,Facture.UOCleRepartitionClient,Facture.NombreTotalUO,facture.PrixUnitaireUO, facture.NombreUOClient,facture.QuotePartClient, Facture.ClientNiveau1 , Facture.ClientNiveau2
ORDER BY Facture.ApplicationGroupeApplication, Facture.FamilleService, Facture.CritereTri, Facture.Service, Facture.CategorieApplication, Facture.PrixService |
Partager