SELECT CLI.DOS, CLI.TIERS, CLI.NOM, CLI.RUE, CLI.LOC, CLI.CPOSTAL, CLI.VIL, CLI.TEL, CLI.EMAIL, CLI.NAF, CLI.ORIGCOD, ENT.PIDT, CLI.REPR_0001, ENT.PINO, ENT.PINOTIERS, ENT.PIREF, ENT.HTMT, ENT.CE4, T2.TIT, T2.NOM, T2.PRENOM, 
TABLE_TITRE_RAISON_SOCIALE_V.LIBELLE, T2.TEL, T2.TELGSM, T2.EMAIL, T2.FCTCOD_0001, T2.FCTCOD_0002, T2.FCTCOD_0003, CLI.PAY, T2.CONTACT
FROM CARTOFLEX.dbo.CLI CLI, CARTOFLEX.dbo.ENT ENT, CARTOFLEX.dbo.T2 T2, CARTOFLEX.dbo.TABLE_TITRE_RAISON_SOCIALE_V TABLE_TITRE_RAISON_SOCIALE_V
WHERE ENT.TIERS = CLI.TIERS AND T2.DOS = CLI.DOS AND T2.TIERS = CLI.TIERS 
AND TABLE_TITRE_RAISON_SOCIALE_V.DOSC = CLI.DOS AND TABLE_TITRE_RAISON_SOCIALE_V.TITRE = CLI.TIT 
AND ((CLI.DOS='1') AND (ENT.PIDT>'2020-12-31') AND (ENT.CE4='1')) 




/****	TEST		***/

SELECT CARTOFLEX_CONTACTS_CLIENT_V.NOMTIERS, CARTOFLEX_CONTACTS_CLIENT_V.TIERS, CARTOFLEX_CONTACTS_CLIENT_V.VIL, CARTOFLEX_CONTACTS_CLIENT_V.USERCRDH, CARTOFLEX_CONTACTS_CLIENT_V.ORIGCOD 
FROM CARTOFLEX.dbo.CARTOFLEX_CONTACTS_CLIENT_V CARTOFLEX_CONTACTS_CLIENT_V
WHERE (CARTOFLEX_CONTACTS_CLIENT_V.NOM Like '%AL%') AND (CARTOFLEX_CONTACTS_CLIENT_V.USERCRDH BETWEEN '2022-01-01 00:00:01' AND '2022-12-31 23:30:00');



SELECT T2.TIERS, T2.FCTCOD_0001, T2.EMAIL, T2.TIT, T2.NOM, T2.PRENOM
FROM CARTOFLEX.dbo.T2 T2
WHERE (T2.TIERS='C0007992')

SELECT T2.TIERS, T2.FCTCOD_0001, T2.EMAIL, T2.TIT, T2.NOM, T2.PRENOM
FROM CARTOFLEX.dbo.T2 T2
WHERE (T2.TIERS='C0007992')