How to find duplicate data in two tables,then listing it?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Urgent work! I have two excel membership database, Club A & Club B.

I need to find out all the members who join Club A & B, and Club A members
who haven't join Club B. I will need to check it by tracing the IC(unique:
combine characters & numbers)

Anyone can advise on this? As for as I know, SQL able to solve this. Is it
possible to solve it in Excel and Access?

Thanks!
 
In Access you just use a SQL query. This will give you all the Club A
members who are not members of Club B

SELECT a.IC FROM ClubA a
LEFT OUTER JOIN ClubB b
 
I also have a little Excel file that will run a query against two
single-column lists in another workbook and return the unique entries in each
list that are NOT in the other list. If you post your email address I'll
send it to you
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting multiple memberships 1
A Brexit Story 1
Relationships 1
Formula question 3
find and copy rows based on dates in two columns 3
simple accounting database 2
How to enter date as text 6
Table Design - stuck! 4

Back
Top