I have produced a query which relates two tables, aircraft and pilots.
In some cases there are no pilots who meet the condition PILOTS.PI_SEQ_NO=POLCOUNT. When this happens nothing is stored in the resultant cursor. Here is the query

SELECT *;
FROM RFQCURSOR LEFT OUTER JOIN YELLOW1!PILOTS;
ON RFQCURSOR.NNUMBER_A=PILOTS.NNUMBER;
WHERE PILOTS.PI_SEQ_NO=POLCOUNT;
INTO CURSOR RFQCURSOR NOFILTER

If there are no pilots I would like the query to keep the old contents of rfqcursor, Anyone have any ideas how to proceed.