1 2 3
| INSERT INTO Clients
SELECT [a_Clients].[Code Point de vente] AS CodePointDeVente, [a_Clients].[Code Client Actif Ce Jour] AS CodeClient, [a_Clients].[Numéro administration fisc] AS CodeDouane, [a_Clients].[Code NIM] AS CodeNim, [a_Clients].[Code SIREN] AS CodeSiren, [a_Clients].[Date début gérance] AS DateDébutGérance, [a_Clients].[Classe Client] AS ClasseClient, [a_Clients].[Nom Client] AS NomClient, [a_Clients].[Enseigne] AS Enseigne, [a_Clients].[Adresse1+2+3] AS AdresseClient, [a_Clients].[Département postal] AS DépartementPostal, [a_Clients].[Code postal] AS CP, [a_Clients].[Bureau distributeur] AS BureauDeDistribution, [a_Clients].[Code INSEE] AS CodeInsee, [a_Clients].[Libellé commune INSEE] AS LibelléCommune, [a_Clients].[Téléphone] AS Téléphone, [a_Clients].[Ligne TPV] AS LigneStrator, [a_Clients].[Mode de paiement] AS ModePaiement, [a_Clients].[DRD du Client (Libellé)] AS LibelléDRD, [a_Clients].[Fréquence livraison] AS FréqLivraison
FROM a_Clients; |
Partager