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...

Please Help.

Kind Regards,
Rob

SELECT b.eventName
FROM MEMBER_EVENT a
    JOIN EVENT b ON a.eventID = b.eventID
WHERE a.memberID = x


Adam Gossage
Lake Wylie, SC, USA