SELECT PRO.TIERS, PRO.DOS, PRO.USERCRDH, PRO.REPR_0001, PRO.TIT, TABLE_TITRE_RAISON_SOCIALE_V.LIBELLE, PRO.NOM, PRO.RUE, PRO.LOC, PRO.CPOSTAL, PRO.VIL, PRO.TEL, PRO.EMAIL, PRO.NAF, PRO.ORIGCOD, PRO.STAT_0001, PRO.STAT_0002, T2.CONTACT, T2.TIT, T2.NOM, T2.PRENOM, T2.LIB, T2.TEL, T2.TELGSM, T2.EMAIL, T2.FCTCOD_0001, T2.FCTCOD_0002, T2.FCTCOD_0003, ENT.PICOD, ENT.PIDT, PRO.HSDT
FROM CARTOFLEX.dbo.ENT ENT, 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 = ENT.DOS AND PRO.TIERS = ENT.TIERS AND ((PRO.DOS='1') AND (ENT.PIDT>'2021-12-31'))