Sergey,

Thank for your Help.

This is a difficult query !

I try this code this night and it seems to function...

*-- WARNING
SET ENGINE BEHAVIOR 70 && Because The clause 'DISTINCT' is not allowed...

 SELECT DISTINCT   Rep.iid AS 'irep',;
      Rep.lcopyfact,;
      R.iid AS 'ires',;
      ve.cnofact,;
      ve.iid,;
      ve.gcommentfamille AS 'memoFam';
      FROM amline!cFiltre cf;
      INNER JOIN amline!Vente ve ON  cf.ichoixId = ve.iid ;
      INNER JOIN amline!RESIDENT R ON  ve.itelephoneid = R.itelephoneid;
      INNER JOIN amline!Archfact   ON  ve.iid = Archfact.iventeid ;
      LEFT JOIN amline!REPONDANT Rep ON  R.iid = Rep.IRESIDENTID AND Rep.lcopyfact= .T. ;
      ORDER BY Rep.iid WHERE cf.lactif = .T.  AND cf.ireport = 92 INTO CURSOR TempCrystal

IF I Want SET ENGINE BEHAVIOR 90 What must I modify?

Thank For your Help

bernhart