troubleshooting Question

Find non-matching records

Avatar of flscooter
flscooter asked on
Crystal Reports
3 Comments1 Solution447 ViewsLast Modified:
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.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 3 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros