I have a union select like this:

SELECT Personal.NoMember FROM Personal;
 UNION;
SELECT Personal.NoMember2 AS NoMember FROM Personal;
 UNION;
SELECT Personal.NoMember3 AS NoMember FROM Personal;

Now, I need to enhance that select so I can have a group by NoMember with the COUNT(*). And, I also need to INNER JOIN that to the Member table so I will be able to get the first name and last name.

I am not sure about the proper syntax for that. I guess I will need to have some sub select.