>Given two cursors with a common field, is there a slick way (using a SQL select command rather than scanning one of the tables and doing seeks on the other) to find all records in cursorA that are not in cursorB?
>
>Thanks in advance,
>Stan
SELECT * FROM cursorA ;
WHERE keyfield NOT IN (SELECT keyfield FROM cursorB)
--sb--