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