>>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?

Yeah, the semicolon after the ORDER BY clause. :-( Also, you could ORDER BY 1 instead, if that did what you wanted....