Hi,

I HAVE.


CREATE CURSOR tp1 ( cnomt C(28) ,;
iemplId I,;
D01 C(4),;
D02 C(4))

CREATE CURSOR tp2 ( cnomt C(28) ,;
iemplId I,;
D01b C(4),;
D02b C(4))


I want all record from tp1 AND tp2

This command do'nt give a good résultat

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


bernhart