SELECT PRO.DOS, ENT.TIERS, ENT.CE4, ENT.TICOD, ENT.HTMT, ENT.TTCMT, ENT.PIDT, ENT.PICOD, PRO.REPR_0001
FROM CARTOFLEX.dbo.ENT ENT, CARTOFLEX.dbo.PRO PRO
WHERE PRO.DOS = ENT.DOS AND ENT.ENT_ID = PRO.PRO_ID AND ((ENT.TICOD='P') AND (ENT.PICOD=1) AND (ENT.DOS=1) AND (ENT.REPR_0001='ACS'))


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'))

--	Semble OK