>>

>>select * from myFirstCursor
>>UNION
>>select * from mySecondCursor
>>into cursor curCombinedResults

>
>I get error that the "operation is invalid for a Memo, Blob, General or Picture field". My cursors do have a MEMO field. So the UNION cannot be used when a cursor has a MEMO, right?

Right. Include all fields except for a memo, or you would need to use UNION ALL (but this would not eliminate duplicates).

Alternative solution would be

select * from myFirstCursor
UNION ALL
select MySecond.* from mySecond LEFT JOIN myFirstCursor ;
on mySecond.ID = myFirstCursor.ID where myFirstCursor.ID IS NULL

The second select selects only records that are not found in first cursor.