I probably did not provide enough info the first time. The members table
is setup as follows:
Id (primary key)
Referer (relates to the primary key of the table)
I am given a member ID, say 4. I need to display all members who have
been referred by member 4 (obviously no problem). However, for ea
As a follow up to my previous question, two possible solutions came to
mind:
1) Query members table for all members matching criteria stored in that
table (country, marital status, income, etc). Then, take all those
member_ids, and query member_interests table for members who match
there. i.e.,
S