More Query Help [more info]

2002-06-05 Thread Daren Cotter
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

Query Help (more)

2002-05-31 Thread Daren Cotter
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