1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
|
SELECT DISTINCT
Contact.Nom AS Nom,
Contact.NumContact AS NumContact,
Contact.Prenom AS Prenom,
Contact.Civilite AS Civilite,
Client.Société AS Société,
Client.Adresse AS Adresse_Cl,
Client.CodePostal AS CodePostal_Cl,
Client.Ville AS Ville_Cl,
Client.Téléphone1 AS Téléphone1,
Client.EMail AS EMail_Cl,
Client.Type AS Type,
Client.Proprietaire AS Proprietaire,
Client.NumClient AS NumClient_Cl,
Client.Prof_part AS Prof_part,
Contact.ContactDefaut AS ContactDefaut,
Client.Nbreemploye AS Nbreemploye,
FINANCEUR_Client.IDFINANCEUR AS IDFINANCEUR
FROM
Client LEFT OUTER JOIN FINANCEUR_Client ON FINANCEUR_Client.NumClient = Client.NumClient,
Client LEFT OUTER JOIN Contact ON Contact.NumClient = Client.NumClient
WHERE
(
Client.Proprietaire = {Param_Proprio}
AND Client.Type = {Param_Type}
AND Client.Prof_part = 0
AND Contact.ContactDefaut = 1
AND FINANCEUR_Client.IDFINANCEUR = {Param_id_financeur}
)
ORDER BY
Société ASC |
Partager