There was an article posted about a month ago about many-to-many relationships. I have the following Question:
I need to create a many-to-many relationship where members can select interests, like follows:
members:
--------
member_id, lots_more_stuff
interests:
----------
interest_id, name_of_interest
member_interests:
-----------------
member_id, interest_id
Question is this: I need to select member info WHERE a member has two different interests. How/can I do this in one query?
I.E.,
SELECT first_name, last_name, email FROM members WHERE (member has skiing, and boating as interests)...
Anyone?
I need to create a many-to-many relationship where members can select interests, like follows:
members:
--------
member_id, lots_more_stuff
interests:
----------
interest_id, name_of_interest
member_interests:
-----------------
member_id, interest_id
Question is this: I need to select member info WHERE a member has two different interests. How/can I do this in one query?
I.E.,
SELECT first_name, last_name, email FROM members WHERE (member has skiing, and boating as interests)...
Anyone?