----- Mailing Clients Scolaire ----- DSN=SQL Divalto;Description=Connexion au serveur SQL de Divalto;UID=edarblay;Trusted_Connection=Yes;APP=Microsoft Office 2013;WSID=CARTO-14-ASSCOM;DATABASE=CARTOFLEX SELECT CLI.DOS, CLI.TIERS, CLI.TIT, TABLE_TITRE_RAISON_SOCIALE_V.LIBELLE, CLI.NOM, CLI.RUE, CLI.LOC, CLI.CPOSTAL, CLI.VIL, CLI.PAY, CLI.TEL, CLI.FAX, CLI.EMAIL, CLI.STAT_0001, CLI.STAT_0002, CLI.REPR_0001, T2.TIT, T2.NOM, T2.PRENOM, CLI.STAT_0001 FROM CARTOFLEX.dbo.CLI CLI, CARTOFLEX.dbo.T2 T2, CARTOFLEX.dbo.TABLE_TITRE_RAISON_SOCIALE_V TABLE_TITRE_RAISON_SOCIALE_V WHERE CLI.DOS = T2.DOS AND T2.TIERS = CLI.TIERS AND TABLE_TITRE_RAISON_SOCIALE_V.DOSC = T2.DOS AND TABLE_TITRE_RAISON_SOCIALE_V.TITRE = CLI.TIT ----- REQUETE DES COMMANDES DU MOIS OCTOBRE 2015 ----- DSN=SQL Divalto;Description=Connexion au serveur SQL de Divalto;UID=edarblay;Trusted_Connection=Yes;APP=Microsoft Office 2013;WSID=CARTO-14-COMPTA;DATABASE=CARTOFLEX SELECT CLI.DOS, CLI.TIERS, CLI.NOM, CLI.CPOSTAL, CLI.REPR_0001, ENT.PIDT, ENT.DELDEMDT, ENT.PINO, ENT.PINOTIERS, ENT.PIREF FROM CARTOFLEX.dbo.CLI CLI, CARTOFLEX.dbo.ENT ENT WHERE ENT.TIERS = CLI.TIERS AND ((CLI.DOS=1) AND (ENT.PICOD=2) AND (ENT.PIDT>'2020-12-31') AND (CLI.REPR_0001='ACS')) ----- REQUETE GLOBALE CLIENTS ----- DSN=SQL Divalto;Description=Connexion au serveur SQL de Divalto;UID=edarblay;Trusted_Connection=Yes;APP=Microsoft Office 2013;WSID=CARTO-14-ASSCOM;DATABASE=CARTOFLEX SELECT CARTOFLEX_CONTACTS_CLIENT_V.ADRCOD_0001, CARTOFLEX_CONTACTS_CLIENT_V.ADRCOD_0002, CARTOFLEX_CONTACTS_CLIENT_V.ADRCOD_0003, CARTOFLEX_CONTACTS_CLIENT_V.ADRCOD_0004, CARTOFLEX_CONTACTS_CLIENT_V."ANNEE N", CARTOFLEX_CONTACTS_CLIENT_V."ANNEE N-1", CARTOFLEX_CONTACTS_CLIENT_V.ARMTBTAG_0001, CARTOFLEX_CONTACTS_CLIENT_V.ARMTBTAG_0002, CARTOFLEX_CONTACTS_CLIENT_V.ARMTBTAG_0003, CARTOFLEX_CONTACTS_CLIENT_V.ARMTBTAG_0004, CARTOFLEX_CONTACTS_CLIENT_V.ARMTBTAG_0005, CARTOFLEX_CONTACTS_CLIENT_V.ARMTBTAG_0006, CARTOFLEX_CONTACTS_CLIENT_V.ARMTBTAG_0007, CARTOFLEX_CONTACTS_CLIENT_V.ARMTBTAG_0008, CARTOFLEX_CONTACTS_CLIENT_V."CA 3 MOIS", CARTOFLEX_CONTACTS_CLIENT_V."CA MOIS", CARTOFLEX_CONTACTS_CLIENT_V.CE1, CARTOFLEX_CONTACTS_CLIENT_V.CE2, CARTOFLEX_CONTACTS_CLIENT_V.CE3, CARTOFLEX_CONTACTS_CLIENT_V.CE4, CARTOFLEX_CONTACTS_CLIENT_V.CE5, CARTOFLEX_CONTACTS_CLIENT_V.CE6, CARTOFLEX_CONTACTS_CLIENT_V.CE7, CARTOFLEX_CONTACTS_CLIENT_V.CE8, CARTOFLEX_CONTACTS_CLIENT_V.CE9, CARTOFLEX_CONTACTS_CLIENT_V.CEA, CARTOFLEX_CONTACTS_CLIENT_V.CONTACT, CARTOFLEX_CONTACTS_CLIENT_V.CPOSTAL, CARTOFLEX_CONTACTS_CLIENT_V.CPT, CARTOFLEX_CONTACTS_CLIENT_V.DOPDH, CARTOFLEX_CONTACTS_CLIENT_V.DOS, CARTOFLEX_CONTACTS_CLIENT_V.EMAIL, CARTOFLEX_CONTACTS_CLIENT_V.EMAILCONTACT, CARTOFLEX_CONTACTS_CLIENT_V.ENMAX_0001, CARTOFLEX_CONTACTS_CLIENT_V.ENMAX_0002, CARTOFLEX_CONTACTS_CLIENT_V.FAX, CARTOFLEX_CONTACTS_CLIENT_V.FEU, CARTOFLEX_CONTACTS_CLIENT_V.FONCTION1, CARTOFLEX_CONTACTS_CLIENT_V.FONCTION10, CARTOFLEX_CONTACTS_CLIENT_V.FONCTION2, CARTOFLEX_CONTACTS_CLIENT_V.FONCTION3, CARTOFLEX_CONTACTS_CLIENT_V.FONCTION4, CARTOFLEX_CONTACTS_CLIENT_V.FONCTION5, CARTOFLEX_CONTACTS_CLIENT_V.FONCTION6, CARTOFLEX_CONTACTS_CLIENT_V.FONCTION7, CARTOFLEX_CONTACTS_CLIENT_V.FONCTION8, CARTOFLEX_CONTACTS_CLIENT_V.FONCTION9, CARTOFLEX_CONTACTS_CLIENT_V.HSDT, CARTOFLEX_CONTACTS_CLIENT_V.LIBELLECONTACT, CARTOFLEX_CONTACTS_CLIENT_V.LIBELLEFONCTION1, CARTOFLEX_CONTACTS_CLIENT_V.LIBELLEFONCTION2, CARTOFLEX_CONTACTS_CLIENT_V.LIBELLEFONCTION3, CARTOFLEX_CONTACTS_CLIENT_V.LIBELLEFONCTION4, CARTOFLEX_CONTACTS_CLIENT_V.LIBELLEFONCTION5, CARTOFLEX_CONTACTS_CLIENT_V.LIBELLEFONCTION6, CARTOFLEX_CONTACTS_CLIENT_V.LIBELLEFONCTION7, CARTOFLEX_CONTACTS_CLIENT_V.LIBELLEFONCTION8, CARTOFLEX_CONTACTS_CLIENT_V.LIBELLEFONCTION9, CARTOFLEX_CONTACTS_CLIENT_V.LOC, CARTOFLEX_CONTACTS_CLIENT_V.NAF, CARTOFLEX_CONTACTS_CLIENT_V.NBEX_0001, CARTOFLEX_CONTACTS_CLIENT_V.NBEX_0002, CARTOFLEX_CONTACTS_CLIENT_V.NBEX_0003, CARTOFLEX_CONTACTS_CLIENT_V.NBEX_0004, CARTOFLEX_CONTACTS_CLIENT_V.NBPASSAGE, CARTOFLEX_CONTACTS_CLIENT_V.NBPOINT, CARTOFLEX_CONTACTS_CLIENT_V.NOM, CARTOFLEX_CONTACTS_CLIENT_V.NOMCOMTACT, CARTOFLEX_CONTACTS_CLIENT_V.ORIGCOD, CARTOFLEX_CONTACTS_CLIENT_V.PAY, CARTOFLEX_CONTACTS_CLIENT_V.PRENOM, CARTOFLEX_CONTACTS_CLIENT_V."RAISON SOCIAL CLIENT", CARTOFLEX_CONTACTS_CLIENT_V.REGL, CARTOFLEX_CONTACTS_CLIENT_V.REPR_0001, CARTOFLEX_CONTACTS_CLIENT_V.RUE, CARTOFLEX_CONTACTS_CLIENT_V.SALNB, CARTOFLEX_CONTACTS_CLIENT_V.SIRET, CARTOFLEX_CONTACTS_CLIENT_V.STAT_0001, CARTOFLEX_CONTACTS_CLIENT_V.STAT_0002, CARTOFLEX_CONTACTS_CLIENT_V.STAT_0003, CARTOFLEX_CONTACTS_CLIENT_V.TEL, CARTOFLEX_CONTACTS_CLIENT_V.TELEPHONE, CARTOFLEX_CONTACTS_CLIENT_V.TELMOBILE, CARTOFLEX_CONTACTS_CLIENT_V.TIERS, CARTOFLEX_CONTACTS_CLIENT_V.TIT, CARTOFLEX_CONTACTS_CLIENT_V.TITRE, CARTOFLEX_CONTACTS_CLIENT_V.TITRELIBELLE, CARTOFLEX_CONTACTS_CLIENT_V.USERCR, CARTOFLEX_CONTACTS_CLIENT_V.USERCRDH, CARTOFLEX_CONTACTS_CLIENT_V.USERMO, CARTOFLEX_CONTACTS_CLIENT_V.USERMODH, CARTOFLEX_CONTACTS_CLIENT_V.VIL FROM CARTOFLEX.dbo.CARTOFLEX_CONTACTS_CLIENT_V CARTOFLEX_CONTACTS_CLIENT_V ----- REQUETE GLOBALE PROSPECTS ----- DSN=SQL Divalto;Description=Connexion au serveur SQL de Divalto;UID=vcharni;Trusted_Connection=Yes;APP=Microsoft Office 2013;WSID=CARTO-14-COMPTA;DATABASE=CARTOFLEX SELECT CARTOFLEX_CONTACTS_PROSPECT_V.T2_ID, CARTOFLEX_CONTACTS_PROSPECT_V.DOSSIER, CARTOFLEX_CONTACTS_PROSPECT_V.CLE_CONTACT_PROSPECT, CARTOFLEX_CONTACTS_PROSPECT_V.TIERST2, CARTOFLEX_CONTACTS_PROSPECT_V.NOMTIERS, CARTOFLEX_CONTACTS_PROSPECT_V.CONTACT, CARTOFLEX_CONTACTS_PROSPECT_V.NOMABREGE, CARTOFLEX_CONTACTS_PROSPECT_V.NOMCOMTACT, CARTOFLEX_CONTACTS_PROSPECT_V.PRENOM, CARTOFLEX_CONTACTS_PROSPECT_V.TITRE, CARTOFLEX_CONTACTS_PROSPECT_V.LIBELLECONTACT, CARTOFLEX_CONTACTS_PROSPECT_V.TELEPHONE, CARTOFLEX_CONTACTS_PROSPECT_V.TELMOBILE, CARTOFLEX_CONTACTS_PROSPECT_V.FAXCONTACT, CARTOFLEX_CONTACTS_PROSPECT_V.EMAILCONTACT, CARTOFLEX_CONTACTS_PROSPECT_V.CODESERVICE, CARTOFLEX_CONTACTS_PROSPECT_V.TITRELIBELLE, CARTOFLEX_CONTACTS_PROSPECT_V.DATEFINVALID, CARTOFLEX_CONTACTS_PROSPECT_V.NUMERONOTE, CARTOFLEX_CONTACTS_PROSPECT_V.PRESENCENOTE, CARTOFLEX_CONTACTS_PROSPECT_V.CODEADRESSE, CARTOFLEX_CONTACTS_PROSPECT_V.FONCTION1, CARTOFLEX_CONTACTS_PROSPECT_V.FONCTION2, CARTOFLEX_CONTACTS_PROSPECT_V.FONCTION3, CARTOFLEX_CONTACTS_PROSPECT_V.FONCTION4, CARTOFLEX_CONTACTS_PROSPECT_V.FONCTION5, CARTOFLEX_CONTACTS_PROSPECT_V.FONCTION6, CARTOFLEX_CONTACTS_PROSPECT_V.FONCTION7, CARTOFLEX_CONTACTS_PROSPECT_V.FONCTION8, CARTOFLEX_CONTACTS_PROSPECT_V.FONCTION9, CARTOFLEX_CONTACTS_PROSPECT_V.FONCTION10, CARTOFLEX_CONTACTS_PROSPECT_V.LIBELLEFONCTION1, CARTOFLEX_CONTACTS_PROSPECT_V.LIBELLEFONCTION2, CARTOFLEX_CONTACTS_PROSPECT_V.LIBELLEFONCTION3, CARTOFLEX_CONTACTS_PROSPECT_V.LIBELLEFONCTION4, CARTOFLEX_CONTACTS_PROSPECT_V.LIBELLEFONCTION5, CARTOFLEX_CONTACTS_PROSPECT_V.LIBELLEFONCTION6, CARTOFLEX_CONTACTS_PROSPECT_V.LIBELLEFONCTION7, CARTOFLEX_CONTACTS_PROSPECT_V.LIBELLEFONCTION8, CARTOFLEX_CONTACTS_PROSPECT_V.LIBELLEFONCTION9, CARTOFLEX_CONTACTS_PROSPECT_V.LIBELLEFONCTION10, CARTOFLEX_CONTACTS_PROSPECT_V.NUMEROJOINT, CARTOFLEX_CONTACTS_PROSPECT_V.INDICJOINT, CARTOFLEX_CONTACTS_PROSPECT_V.INDICATEURINTERCO, CARTOFLEX_CONTACTS_PROSPECT_V."RAISON SOCIAL PROSPECT", CARTOFLEX_CONTACTS_PROSPECT_V.PRO_ID, CARTOFLEX_CONTACTS_PROSPECT_V.CE1, CARTOFLEX_CONTACTS_PROSPECT_V.CE2, CARTOFLEX_CONTACTS_PROSPECT_V.CE3, CARTOFLEX_CONTACTS_PROSPECT_V.CE4, CARTOFLEX_CONTACTS_PROSPECT_V.CE5, CARTOFLEX_CONTACTS_PROSPECT_V.CE6, CARTOFLEX_CONTACTS_PROSPECT_V.CE7, CARTOFLEX_CONTACTS_PROSPECT_V.CE8, CARTOFLEX_CONTACTS_PROSPECT_V.CE9, CARTOFLEX_CONTACTS_PROSPECT_V.CEA, CARTOFLEX_CONTACTS_PROSPECT_V.DOS, CARTOFLEX_CONTACTS_PROSPECT_V.TIERS, CARTOFLEX_CONTACTS_PROSPECT_V.USERCR, CARTOFLEX_CONTACTS_PROSPECT_V.USERMO, CARTOFLEX_CONTACTS_PROSPECT_V.CONF, CARTOFLEX_CONTACTS_PROSPECT_V.VISA, CARTOFLEX_CONTACTS_PROSPECT_V.NOMABR, CARTOFLEX_CONTACTS_PROSPECT_V.NOM, CARTOFLEX_CONTACTS_PROSPECT_V.ADRCPL1, CARTOFLEX_CONTACTS_PROSPECT_V.ADRCPL2, CARTOFLEX_CONTACTS_PROSPECT_V.RUE, CARTOFLEX_CONTACTS_PROSPECT_V.LOC, CARTOFLEX_CONTACTS_PROSPECT_V.VIL, CARTOFLEX_CONTACTS_PROSPECT_V.PAY, CARTOFLEX_CONTACTS_PROSPECT_V.CPOSTAL, CARTOFLEX_CONTACTS_PROSPECT_V.ZIPCOD, CARTOFLEX_CONTACTS_PROSPECT_V.REGIONCOD, CARTOFLEX_CONTACTS_PROSPECT_V.INSEECOD, CARTOFLEX_CONTACTS_PROSPECT_V.TEL, CARTOFLEX_CONTACTS_PROSPECT_V.FAX, CARTOFLEX_CONTACTS_PROSPECT_V.WEB, CARTOFLEX_CONTACTS_PROSPECT_V.EMAIL, CARTOFLEX_CONTACTS_PROSPECT_V.NAF, CARTOFLEX_CONTACTS_PROSPECT_V.TIT, CARTOFLEX_CONTACTS_PROSPECT_V.REGL, CARTOFLEX_CONTACTS_PROSPECT_V.DEV, CARTOFLEX_CONTACTS_PROSPECT_V.LANG, CARTOFLEX_CONTACTS_PROSPECT_V.CPT, CARTOFLEX_CONTACTS_PROSPECT_V.CPTMSK, CARTOFLEX_CONTACTS_PROSPECT_V.SELCOD, CARTOFLEX_CONTACTS_PROSPECT_V.SIRET, CARTOFLEX_CONTACTS_PROSPECT_V.ETB, CARTOFLEX_CONTACTS_PROSPECT_V.USERCRDH, CARTOFLEX_CONTACTS_PROSPECT_V.USERMODH, CARTOFLEX_CONTACTS_PROSPECT_V.HSDT, CARTOFLEX_CONTACTS_PROSPECT_V.NOTE, CARTOFLEX_CONTACTS_PROSPECT_V.CENOTE, CARTOFLEX_CONTACTS_PROSPECT_V.JOINT, CARTOFLEX_CONTACTS_PROSPECT_V.CEJOINT, CARTOFLEX_CONTACTS_PROSPECT_V.IDCONNECT, CARTOFLEX_CONTACTS_PROSPECT_V.CLDCOD, CARTOFLEX_CONTACTS_PROSPECT_V.GLN, CARTOFLEX_CONTACTS_PROSPECT_V.TELCLE, CARTOFLEX_CONTACTS_PROSPECT_V.ICPFL, CARTOFLEX_CONTACTS_PROSPECT_V.TACOD, CARTOFLEX_CONTACTS_PROSPECT_V.REMCOD, CARTOFLEX_CONTACTS_PROSPECT_V.PROMOTACOD, CARTOFLEX_CONTACTS_PROSPECT_V.PROMOREMCOD, CARTOFLEX_CONTACTS_PROSPECT_V.TAFAM, CARTOFLEX_CONTACTS_PROSPECT_V.TAFAMX, CARTOFLEX_CONTACTS_PROSPECT_V.REFAM, CARTOFLEX_CONTACTS_PROSPECT_V.REFAMX, CARTOFLEX_CONTACTS_PROSPECT_V.REM_0001, CARTOFLEX_CONTACTS_PROSPECT_V.REM_0002, CARTOFLEX_CONTACTS_PROSPECT_V.REM_0003, CARTOFLEX_CONTACTS_PROSPECT_V.REMTYP_0001, CARTOFLEX_CONTACTS_PROSPECT_V.REMTYP_0002, CARTOFLEX_CONTACTS_PROSPECT_V.REMTYP_0003, CARTOFLEX_CONTACTS_PROSPECT_V.DOPDH, CARTOFLEX_CONTACTS_PROSPECT_V.NBEX_0001, CARTOFLEX_CONTACTS_PROSPECT_V.NBEX_0002, CARTOFLEX_CONTACTS_PROSPECT_V.NBEX_0003, CARTOFLEX_CONTACTS_PROSPECT_V.NBEX_0004, CARTOFLEX_CONTACTS_PROSPECT_V.EDITTYP_0001, CARTOFLEX_CONTACTS_PROSPECT_V.EDITTYP_0002, CARTOFLEX_CONTACTS_PROSPECT_V.EDITTYP_0003, CARTOFLEX_CONTACTS_PROSPECT_V.EDITTYP_0004, CARTOFLEX_CONTACTS_PROSPECT_V.ETANO_0001, CARTOFLEX_CONTACTS_PROSPECT_V.ETANO_0002, CARTOFLEX_CONTACTS_PROSPECT_V.ETANO_0003, CARTOFLEX_CONTACTS_PROSPECT_V.ETANO_0004, CARTOFLEX_CONTACTS_PROSPECT_V.AXEMSK, CARTOFLEX_CONTACTS_PROSPECT_V.AXENO, CARTOFLEX_CONTACTS_PROSPECT_V.STLGTGAMCOD, CARTOFLEX_CONTACTS_PROSPECT_V.WMAUDITFL, CARTOFLEX_CONTACTS_PROSPECT_V.WMDOCEMP, CARTOFLEX_CONTACTS_PROSPECT_V.WMRESAIMPFL, CARTOFLEX_CONTACTS_PROSPECT_V.TRANSPLANCOD, CARTOFLEX_CONTACTS_PROSPECT_V.TEXCOD_0001, CARTOFLEX_CONTACTS_PROSPECT_V.TEXCOD_0002, CARTOFLEX_CONTACTS_PROSPECT_V.TEXCOD_0003, CARTOFLEX_CONTACTS_PROSPECT_V.TEXCOD_0004, CARTOFLEX_CONTACTS_PROSPECT_V.TEXCOD_0005, CARTOFLEX_CONTACTS_PROSPECT_V.TEXCOD_0006, CARTOFLEX_CONTACTS_PROSPECT_V.TEXCOD_0007, CARTOFLEX_CONTACTS_PROSPECT_V.TEXCOD_0008, CARTOFLEX_CONTACTS_PROSPECT_V.AFFCLDCOD, CARTOFLEX_CONTACTS_PROSPECT_V.IDENTITEEXT, CARTOFLEX_CONTACTS_PROSPECT_V.STAT_0001, CARTOFLEX_CONTACTS_PROSPECT_V.STAT_0002, CARTOFLEX_CONTACTS_PROSPECT_V.STAT_0003, CARTOFLEX_CONTACTS_PROSPECT_V.TPFT, CARTOFLEX_CONTACTS_PROSPECT_V.TIERSGRP, CARTOFLEX_CONTACTS_PROSPECT_V.ZONA, CARTOFLEX_CONTACTS_PROSPECT_V.CAMT, CARTOFLEX_CONTACTS_PROSPECT_V.SALNB, CARTOFLEX_CONTACTS_PROSPECT_V.ENMAX_0001, CARTOFLEX_CONTACTS_PROSPECT_V.ENMAX_0002, CARTOFLEX_CONTACTS_PROSPECT_V.ESCP, CARTOFLEX_CONTACTS_PROSPECT_V.ACP, CARTOFLEX_CONTACTS_PROSPECT_V.ZONN, CARTOFLEX_CONTACTS_PROSPECT_V.TVATIE, CARTOFLEX_CONTACTS_PROSPECT_V.TARCOD, CARTOFLEX_CONTACTS_PROSPECT_V.COFAM, CARTOFLEX_CONTACTS_PROSPECT_V.TIERSNAT, CARTOFLEX_CONTACTS_PROSPECT_V.ORIGCOD, CARTOFLEX_CONTACTS_PROSPECT_V.REPR_0001, CARTOFLEX_CONTACTS_PROSPECT_V.REPR_0002, CARTOFLEX_CONTACTS_PROSPECT_V.REPR_0003, CARTOFLEX_CONTACTS_PROSPECT_V.ZONAPC, CARTOFLEX_CONTACTS_PROSPECT_V.QUALCOD, CARTOFLEX_CONTACTS_PROSPECT_V.TIERSCLI, CARTOFLEX_CONTACTS_PROSPECT_V.ARMTBTAG_0001, CARTOFLEX_CONTACTS_PROSPECT_V.ARMTBTAG_0002, CARTOFLEX_CONTACTS_PROSPECT_V.ARMTBTAG_0003, CARTOFLEX_CONTACTS_PROSPECT_V.ARMTBTAG_0004, CARTOFLEX_CONTACTS_PROSPECT_V.ARMTBTAG_0005, CARTOFLEX_CONTACTS_PROSPECT_V.ARMTBTAG_0006, CARTOFLEX_CONTACTS_PROSPECT_V.ARMTBTAG_0007, CARTOFLEX_CONTACTS_PROSPECT_V.ARMTBTAG_0008, CARTOFLEX_CONTACTS_PROSPECT_V."CA MOIS", CARTOFLEX_CONTACTS_PROSPECT_V."CA 3 MOIS", CARTOFLEX_CONTACTS_PROSPECT_V."ANNEE N", CARTOFLEX_CONTACTS_PROSPECT_V."ANNEE N-1" FROM CARTOFLEX.dbo.CARTOFLEX_CONTACTS_PROSPECT_V CARTOFLEX_CONTACTS_PROSPECT_V ----- REQUETE - MAILING CLIENTS SCOLAIRE ----- DSN=SQL Divalto;Description=Connexion au serveur SQL de Divalto;UID=edarblay;Trusted_Connection=Yes;APP=Microsoft Office 2013;WSID=CARTO-14-ASSCOM;DATABASE=CARTOFLEX SELECT CLI.DOS, CLI.TIERS, CLI.TIT, TABLE_TITRE_RAISON_SOCIALE_V.LIBELLE, CLI.NOM, CLI.RUE, CLI.LOC, CLI.CPOSTAL, CLI.VIL, CLI.PAY, CLI.TEL, CLI.FAX, CLI.EMAIL, CLI.STAT_0001, CLI.STAT_0002, CLI.REPR_0001, T2.TIT, T2.NOM, T2.PRENOM, CLI.STAT_0001 FROM CARTOFLEX.dbo.CLI CLI, CARTOFLEX.dbo.T2 T2, CARTOFLEX.dbo.TABLE_TITRE_RAISON_SOCIALE_V TABLE_TITRE_RAISON_SOCIALE_V WHERE CLI.DOS = T2.DOS AND T2.TIERS = CLI.TIERS AND TABLE_TITRE_RAISON_SOCIALE_V.DOSC = T2.DOS AND TABLE_TITRE_RAISON_SOCIALE_V.TITRE = CLI.TIT ----- REQUETE DES COMMANDES DU MOIS OCTOBRE 2015 (DATE DE SAISIE ET DELAI) ----- DSN=SQL Divalto;Description=Connexion au serveur SQL de Divalto;UID=edarblay;Trusted_Connection=Yes;APP=Microsoft Office 2013;WSID=CARTO-14-COMPTA;DATABASE=CARTOFLEX SELECT CLI.DOS, CLI.TIERS, CLI.NOM, CLI.CPOSTAL, CLI.REPR_0001, ENT.PIDT, ENT.DELDEMDT, ENT.PINO, ENT.PINOTIERS, ENT.PIREF FROM CARTOFLEX.dbo.CLI CLI, CARTOFLEX.dbo.ENT ENT WHERE ENT.TIERS = CLI.TIERS AND ((CLI.DOS=1) AND (ENT.PICOD=2) AND (ENT.PIDT>'2020-12-31') AND (CLI.REPR_0001='ACS'))