1 2 3 4
| SELECT Caisse_Num, Caisse_CB, Caisse_GR, Caisse_AutresCartes, Caisse_Date, Debit_Num, Debit_Litre, Debit_CA, Debit_Impaye, Carburant_Num, VP_Num, VP_Prix, Ordre, Produit_Num, Produit_Num, Produit_Lib, FactureE_Num, FactureE_Date, FactureE_Montant, FactureE_Montant, Client_Num, Client_Nom, FactureG_Num, FactureG_Date, FactureG_Montant, FactureG_NomClient, Sum(Est_Vendu_Prix)
FROM CAISSE AS C, DEBIT_TPV AS D, VP AS V, EST_VENDU AS E, PRODUIT AS P, FACTURE_ESSENCE AS FE, CLIENT AS CL, FACTURE_GARAGE AS FG
WHERE C.Caisse_Num=D.Caisse_Num And C.Caisse_Num=V.Caisse_Num And C.Caisse_Num=E.Caisse_Num And C.Caisse_Num=FE.Caisse_Num And E.Produit_Num=P.Produit_Num And FE.Client_Num=CL.Client_Num And C.Caisse_Num=FG.Caisse_Num And Caisse_Num=3
GROUP BY Produit_Num; |
Partager