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., SELECT member_id FROM member_interests WHERE interests_id = (XX) AND member_id IN (list of all member IDs here) 2) #1, reversed, which would make more sense, since I also need name and email. If there's any way to do this in one query, I should do it that way...otherwise, am I close on the best solution? Again, TIA! --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
