Borislav,

sorry i am mistake.....

*-- On unit les 2 tables ( tp1 et tp2 )
SELECT NVL( tp2.cnomt , tp1.cnomt ) AS 'cnomt' ,;
NVL( tp2.cnosecret ,tp2.cnosecret) AS 'cnosecret',;
NVL( tp2.cparaphe , tp2.cparaphe) AS 'cparaphe',;
NVL( tp2.iFoncId ,tp2.iFoncId) AS 'iFoncId' , ;
NVL( tp2.yconso,tp2.yconso) AS 'yconso',;
NVL( tp2.yconson,tp2.yconson) AS 'yconson',;
NVL(tp2.netpsPlAs,tp2.netpsPlAs) AS 'netpsPlAs',;
NVL( tp2.netpsPlNAs, tp2.netpsPlNAs) AS 'netpsPlNAs',;
NVL( tp2.nextrAss,tp2.nextrAss) AS 'nextrAss' ,;
NVL( tp2.nextrNass,tp2.nextrNass) AS 'nextrNass' ,;
NVL( tp2.nOrdreF,tp2.nOrdreF) AS 'nOrdreF',;
NVL( tp2.cnomf,tp2.cnomf) AS 'cnomf',;
NVL( tp2.cPauseNo,tp2.cPauseNo) AS 'cPauseNo',;
NVL( tp2.iemplId,tp2.iemplId) AS 'iemplId',;
NVL( tp2.D01b ,SPACE(4))AS 'D01b',;
NVL( tp2.D02b ,SPACE(4))AS 'D02b',;
NVL( tp2.D03b ,SPACE(4))AS 'D03b',;
NVL( tp2.D04b ,SPACE(4))AS 'D04b',;
NVL( tp2.D05b ,SPACE(4))AS 'D05b',;.......

FOR

  SELECT NVL( tp2.cnomt , tp1.cnomt ) AS 'cnomt' ,;
    NVL( tp2.cnosecret ,tp1.cnosecret) AS 'cnosecret',;
    NVL( tp2.cparaphe , tp1.cparaphe) AS 'cparaphe',;
    NVL( tp2.iFoncId ,tp1.iFoncId) AS 'iFoncId' , ;
    NVL( tp2.yconso,tp1.yconso) AS 'yconso',;
    NVL( tp2.yconson,tp1.yconson) AS 'yconson',;
    NVL(tp2.netpsPlAs,tp1.netpsPlAs) AS 'netpsPlAs',;
    NVL( tp2.netpsPlNAs, tp1.netpsPlNAs) AS 'netpsPlNAs',;
    NVL( tp2.nextrAss,tp1.nextrAss) AS 'nextrAss' ,;
    NVL( tp2.nextrNass,tp1.nextrNass) AS 'nextrNass' ,;
    NVL( tp2.nOrdreF,tp1.nOrdreF) AS 'nOrdreF',;
    NVL( tp2.cnomf,tp1.cnomf) AS 'cnomf',;

Thank borislav




>Bernhart,
>What you not like in that SQL?
>This example returns to me 50 records (as I expect)
>

>CREATE CURSOR tp1 ( cnomt C(28) ,;
>iemplId I,;
>D01 C(4),;
>D02 C(4))
>FOR asd = 1 TO 20
>    INSERT INTO tp1 VALUES (TRANSFORM(asd), asd, "Do01", "DO02")
>NEXT
>
>
>CREATE CURSOR tp2 ( cnomt C(28) ,;
>iemplId I,;
>D01b C(4),;
>D02b C(4))
>FOR asd = 1 TO 50
>    INSERT INTO tp2 VALUES (TRANSFORM(asd), asd, "Do01b", "DO02b")
>NEXT
>
>SELECT NVL( tp2.cnomt , tp1.cnomt ) AS 'cnomt',;
>NVL( tp2.iemplId,tp2.iemplId) AS 'iemplId',;
>NVL( tp2.D01b ,SPACE(4))AS 'D01b',;
>NVL( tp2.D02b ,SPACE(4))AS 'D02b',;
>NVL( tp1.D01 ,SPACE(4))AS 'D01',;
>NVL( tp1.D02 ,SPACE(4))AS 'D02';
>FROM tp2;
>FULL JOIN tp1 ON tp2.iemplId = tp1.iemplId INTO CURSOR Tp
>BROW
>