>

>SELECT * ;
>    FROM cursorA ;
>    INTO CURSOR cursorC ;
>    ORDER BY orderField
>UNION ;
>SELECT * ;
>    FROM cursorB
>

>>
>> Hmmm...this looks good, but when I tried it I only got records from
>> cursorA. Is there something missing?
>>
>the ORDER BY should be in the last SELECT
>also it should be on a field number
>
>btw, another way to do this is with a full outer join on the key field
>

Yes, thanks, that did it:

SELECT * ;
    FROM cursorA ;
    INTO CURSOR cursorC ;
UNION ;
SELECT * ;
    FROM cursorB;
    ORDER BY 1 && for example