1 2 3
| SELECT Clients.Country, [Pays].Zone, Clients.Client, Type.Maker, Type.Type,[Voiture].Model, [Voiture].Serial_number,Options.[Nature Equipement],Options.[Reference], Equipements.NO, Equipements.P2, Equipements.CM, Options.Designation, COUNT [Voiture].Serial_number, Options.[Reference] As Nbre
FROM Equipements INNER JOIN (Type INNER JOIN ([Pays] INNER JOIN (((Clients INNER JOIN [Voiture] ON Clients.Client = [Voiture].Client) INNER JOIN [Lien] ON [Voiture].Serial_number = [Lien].Serial_number) INNER JOIN (SELECT Serial_Number,"Equipement" as [Nature Equipement],Equipements.[Reference],Designation FROM Equipements INNER JOIN Lien ON Lien.Reference=Equipements.Reference UNION SELECT Serial_Number,"Autre Equipement",[Reference], Designation FROM Autres_Equipements) As Options ON [Voiture].Serial_number = Options.Serial_number) ON [Pays].Country = Clients.Country) ON Type.Type = [Voiture].Type) ON Equipements.[Reference] = [Lien].[Reference]
GROUP BY Clients.Country, [Pays].Zone, Clients.Client, Type.Maker, Type.Type, [Voiture].Model, [Voiture].Serial_number, Options.[Nature Equipement],Options.[Reference], Equipements.NO, Equipements.P2, Equipements.CM, Options.Designation |
Partager