SELECT PRO.TIERS, PRO.NOM, PRO.REPR_0001
FROM CARTOFLEX.dbo.PRO PRO
WHERE (PRO.TIERS Like 'P%') AND (PRO.NOM Like 'E%')




SELECT * 
FROM CARTOFLEX.dbo.CARTOFLEX_CONTACTS_PROSPECT_V PRO 
WHERE (PRO.TIERS Like 'P%') AND (PRO.NOM Like 'E%') AND 
(PRO.USERCRDH BETWEEN '2023-01-01 00:30:00' AND '2023-03-01 23:30:00')



SELECT 
PRO.TIERS, 
PRO.DOS, 
PRO.USERCRDH, 
PRO.REPR_0001, 
PRO.TIT, 
TABLE_TITRE_RAISON_SOCIALE_V.LIBELLE, 
PRO.NOM, 
PRO.RUE, PRO.VIL, T2.FCTCOD_0001, T2.FCTCOD_0002, T2.FCTCOD_0003, PRO.CPOSTAL, T2.CONTACT, T2.TIT, T2.NOM, T2.PRENOM, T2.EMAIL, PRO.HSDT, PRO.EMAIL, PRO.STAT_0001, PRO.STAT_0002  
FROM CARTOFLEX.dbo.PRO PRO, CARTOFLEX.dbo.T2 T2, CARTOFLEX.dbo.TABLE_TITRE_RAISON_SOCIALE_V TABLE_TITRE_RAISON_SOCIALE_V  
WHERE PRO.DOS = T2.DOS 
AND T2.TIERS = PRO.TIERS 
AND TABLE_TITRE_RAISON_SOCIALE_V.DOSC = PRO.DOS 
AND TABLE_TITRE_RAISON_SOCIALE_V.TITRE = PRO.TIT AND ((PRO.DOS='1'))