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.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement