Find non-matching records
Posted on 2007-07-20
As someone who spends a lot of time doing MIS, a great deal of my job is finding records that fit a certain criteria. Often times it can be equally important to find the records that don't match. This is what I am having a problem with. I am using CR10, DB2 table MS Access table as input. I have 2 key fields, Account number and Bank number. I am performing an inner join where the keys match for my main report ( about 5,000 recs). That worked out fine. Now I want a report of all of the records on my Access table ( about 7,500 recs on table ) not on my DB2 table ( about 16 million recs ). I can perform a left outer join, but then I must do further machinations to get what I need. I tried using the select expert, where the account numbers aren't equal ( still using inner join ), but I got same 5,000 or so matching recs as result. How can I simply get non-matching outliers in such a scenario? Thanks.