Use a subquery.
select * from IncomingOrders;
where OrderNum not in;
(select OrderNum from OutgoingOrders);
into cursor TmpResult
>I have 2 large files, one file of incomming orders and one file of outgoing orders. They are keyed on the same ID field, a unique integer.
>
>Id like to check and make sure all the items in the input file have a match in the output file. Is there a clean SQL method to find items in one file and not another?
>
>
>TIA
>Chris
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)