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 Arnon