Forum Discussion

PBInonpro's avatar
PBInonpro
Helper III
3 years ago
Solved

Compare Two Tables

I have two tables, one with a list of all members and the other with a list of last month members.

 

how do I compare the two lists to identify those who should have one of the following three statuses?:

 

1) new members to add (on first table / missing from second table)

2) old members to remove (on second table / missing from first table)

3) on both tables (good)