many-to-many help

I have a many-to-many query that is giving me false positives.
Lets say I have some entitiesTeam Members and Teams. Team Members are onTeams, and they could be in one or many Teams. They are represented in tables thusly:
Team Member:
MemberID
TeamMemberName

Team:
TeamID
TeamName

They are associated in this table:
Association:
TeamID
MemberID

I have teams of the following makeup:
Team1:
John
Mary

Team2:
John
Mary
Susan

Team3:
John
Billy

Lets say I have no idea what the teams are, and someone hands me the names John and Mary and tells me I have to find out the single TeamName associated with these people, and only these people. The query I have constructed so far will give me a false positive on Team2.Hi pinkbear and welcome to TSDN !

can you post the query you have as a start point

Regards Purplesql