I thought I`d note here a simple mysql JOIN to remind me how it works. if it jelsp you too then that i sgood.
I wanted to run a query on my people in the database (table: who) and against the list of members in the club (table:mem)
SELECT mem.person, who.email, mem.club
INNER JOIN who ON who.ID = mem.person
WHERE mem.club = `2142`
This returns the person ID, their email and their club identifier. In this case I`m looking to find the email of all members in the club `2142`