1 2 3 4 5 6 7 8 9 10 11 12
| SELECT LnkCliMach.L_DateAchat, LnkCliMach.L_Occasion, TypeMachines.M_TypeMachines, LnkCliMach.L_DesignationMachine, LnkCliMach.L_Actif,
LnkCliMach.L_Contrat, LnkCliMach.L_VenteInterne, LnkCliMach.L_IdClient1, LnkCliMach.L_IdClient2, Clients.C_Nom, Clients.C_IdClient, Clients.C_EMail,
TypeMachines.M_IdTypeMachines
FROM Clients INNER JOIN LnkCliMach
ON Clients.C_IdClient = LnkCliMach.L_IdClient1
INNER JOIN TypeMachines
ON LnkCliMach.L_IdTypeMachine = TypeMachines.M_IdTypeMachines
WHERE (TypeMachines.M_IdTypeMachines = 1)
GROUP BY LnkCliMach.L_DateAchat, LnkCliMach.L_Occasion, TypeMachines.M_TypeMachines, LnkCliMach.L_DesignationMachine, LnkCliMach.L_Actif,
LnkCliMach.L_Contrat, LnkCliMach.L_VenteInterne, LnkCliMach.L_IdClient1, LnkCliMach.L_IdClient2, Clients.C_Nom, Clients.C_IdClient, Clients.C_EMail,
TypeMachines.M_IdTypeMachines
ORDER BY Clients.C_Nom DESC |
Partager