I have 2 tables One called CData and another called Elig. CData has 11000 rows and Sheet has 19806. When joined together 10000 rows match on inner join. I want find the 1000 rows that didnt match in the CDATA table.
FirstName, LastName, DOB, AGE, Address, CIty State, ZIP
I used the Firstname, LastName and DOB to join the 2 tables. But Again I need to find the rows that are in CData and not in Elig. Hope that made since. Thanks