>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

select * from inp where IDfld NOT IN (select IDfld from outp)