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,
Jim Edgar
Jurix Data Corporation
jmedgar@yahoo.comNo trees were destroyed in sending this message. However, a large number of electrons were diverted from their ordinary activities and terribly inconvenienced.