I have two tables. One is participant, with ID, email address and first name. The second is who2who with ID, leader and follower that determines a leader/follower relationship. Each leader can have multiple followers. I set up the indexing from participant.ID to who2who.leader and who2who.follower.
I wanted to search participant.email for the leader and return the list of participant.email addresses for the followers.
INNER JOIN who2who
ON who2who.Leader = participant.p_ID
WHERE participant.email_user = "email@example.com"
What am I doing wrong?