CREATE CURSOR Test (Fld1 Int, Fld2 Char(10)) CREATE CURSOR Test1 (Fld1 Int, Fld2 Char(10)) INSERT INTO Test VALUES (1, [Val 1]) INSERT INTO Test VALUES (2, [Val 2]) INSERT INTO Test VALUES (3, [Val 3]) INSERT INTO Test1 VALUES (1, [Val 1]) INSERT INTO Test1 VALUES (4, [Val 4]) INSERT INTO Test1 VALUES (3, [Val 3]) SELECT NVL(Test.Fld1, Test1.Fld1) AS Fld1,; NVL(Test.Fld2, Test1.Fld2) AS Fld2; FROM Test; FULL JOIN Test1 ON Test.Fld1 = Test1.Fld1; WHERE Test.Fld1 IS NULL OR Test1.Fld1 IS NULL; INTO CURSOR crsTest SELECT crsTest BROWSE NORMAL(assuming that Fld1 is a key field)