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!