1 2 3 4 5
|
SELECT Client.N° AS Num, Client.[ID Cabinet] AS IDCabinet, Client.[Code Civilité] AS CodeCivilite, Client.Dénomination AS Denomination, Client.[Dénomination correspondance], Client.Provenance AS Provenance, Client.[Type client] AS Typeclient, Client.Adresse AS Adresse, Client.[Code postal] AS Codepostal, Client.Ville AS Ville, Client.Pays AS Pays, Client.[Code Utilisateur] AS [Code Utilisateur], Client.[Code dernier modificateur] AS [Code dernier modificateur], Client.[Date dernière modification] AS Datedernieremodification, Client.[Code Client Par] AS [Code Client Par], Client.[Code Client Ent] AS [Code Client Ent], Client.Tel AS Tel, Client.Fax AS Fax, Client.[Tel portable] AS Telportable, Client.[E-MAIL] AS MAIL, [Client Particulier].N° AS NumPart, [Client Particulier].[ID Cabinet] AS IDCabinetPart, [Client Particulier].[N° dans client] AS Numdansclient, [Client Particulier].Civilité AS Civilite, [Client Particulier].Nom AS Nom, [Client Particulier].Prénom AS Prenom, [Client Particulier].Adresse1 AS Adresse1, [Client Particulier].[Code postal] AS CodepostalPart, [Client Particulier].Ville AS VillePart, [Client Particulier].Pays AS PaysPart, [Client Particulier].[Date de naissance] AS Datedenaissance, [Client Particulier].[Situation de famille] AS Situationdefamille, [Client Particulier].[Solde compte client] AS Soldecompteclient, [Client Particulier].[Tel domicile] AS Teldomicile, [Client Particulier].Fax AS FaxPart, [Client Particulier].[Tel portable] AS TelportablePart, [Client Particulier].[Tél sur site] AS Telsursite, [Client Particulier].[Tél res sec] AS Telressec, [Client Particulier].[E-MAIL] AS MAILPart, [Client Particulier].[Tel bureau] AS Telbureau, [Client Particulier].[Code profession] AS Codeprofession, [Client Particulier].Notes AS Notes, [Client Particulier].[Code provenance défaut] AS Codeprovenancedefaut, [Client Particulier].[Code Utilisateur défaut] AS CodeUtilisateurdefaut, [Client Particulier].[Code dernier modificateur] AS Codederniermodificateur, [Client Particulier].[Date dernière modification] AS DatedernieremodificationPart,
[Client Particulier].Daterevisiondossier AS Daterevisiondossier, [Client Particulier].Mensualisé AS Mensualise, [Client Particulier].Prospect AS Prospect, [Client Particulier].Client AS Client, [Client Particulier].[Code Catégorie professionnelle] AS CodeCategorieprofessionnelle, [Client Particulier].[CLT PAR Champ libre 1] AS CLTPARChamplibre1, [Client Particulier].[CLT PAR Champ libre 2] AS CLTPARChamplibre2, [Client Particulier].[code portefeuille] AS codeportefeuille
FROM Client INNER JOIN [Client Particulier] ON Client.N°=[Client Particulier].[N° dans client]; |
Partager