>Thanks, I have a clean list.
>
>The next step is to compare this drawing/rev combo with another table that has drawing/rev records and only list those combos taht don't match.

select Drawing+Revision as DrawRevision from OriginalTable ;
where DrawRevision ;
not in (select Drawing+Revision as DrawRevision from NewTable) ;
into cursor curNotFound

Or try not exist syntax...