Hi all,

Trying to join two cursors so that the result is one cursor with all the records for both. This is the easiest type of union, but I simply cannot remember how it works. What I am doing is resulting in no records selected -- so that's wrong.

SELECT ;
    FField1 AS Field1, ;
    FField2 AS Field2  ;
    FROM myTable1      ;
INTO CURSOR myCursor1 NOFILTER

SELECT ;
    BField1 AS Field1, ;
    BField2 AS Field2  ;
    FROM myTable2      ;
INTO CURSOR myCursor2 NOFILTER

What is the syntax to merge myCursor1 and myCursor2 such that all records in both cursors are included in the merged table?

Thanks for your help.

regards,