//	Ancienne version
SELECT PRO.DOS, PRO.TIERS, PRO.NOM, PRO.RUE, PRO.LOC, PRO.VIL, PRO.CPOSTAL, PRO.REPR_0001, ENT.PICOD, ENT.PIDT, ENT.PINO, ENT.PINOTIERS, ENT.PIREF, ENT.TICOD, T2.CONTACT, T2.TIT, T2.NOM, T2.PRENOM
FROM CARTOFLEX.dbo.ENT ENT, CARTOFLEX.dbo.PRO PRO, CARTOFLEX.dbo.T2 T2
WHERE ENT.TIERS = PRO.TIERS AND ENT.DOS = PRO.DOS AND T2.TIERS = PRO.TIERS AND ((PRO.DOS=1) AND (PRO.REPR_0001='AC') AND (ENT.PICOD=1) AND (ENT.TICOD='P') AND (ENT.PIDT>'2022-01-01' And ENT.PIDT<'2022-07-12')) 

//	Tous les mouvements - Dates à changer
SELECT DISTINCT MOUV.MOUV_ID, MOUV.TIERS, MOUV.REF, MOUV.STATUS, MOUV.PICOD, CLI.EMAIL, CLI.EMAILCONTACT 
FROM MOUV MOUV, CARTOFLEX.dbo.CARTOFLEX_CONTACTS_CLIENT_V CLI 
WHERE MOUV.TIERS = CLI.TIERS 
AND (MOUV.DVDT>'2023-01-01' And MOUV.DVDT<'2023-03-13') AND MOUV.REPR_0001 = 'ACS'
UNION 
SELECT DISTINCT MOUV.MOUV_ID, MOUV.TIERS, MOUV.REF, MOUV.STATUS, MOUV.PICOD, PRO.EMAIL, PRO.EMAILCONTACT 
FROM MOUV MOUV, CARTOFLEX.dbo.CARTOFLEX_CONTACTS_PROSPECT_V PRO 
WHERE MOUV.TIERS = PRO.TIERS 
AND (MOUV.DVDT>'2023-01-01' And MOUV.DVDT<'2023-03-13') AND MOUV.REPR_0001 = 'ACS'