General SELECT question
Could someone tell me how to form a SQL Select where I have:
a) A MEMBER table with memberID and memberName
b) A EVENT table with eventID and eventName
c) A MEMBER_EVENT table with m_eID and eventID, memberID
Given a memberID "x" I want to select all the eventName's associated with that member in the MEMBER_EVENT table...