I have a many-to-many query that is giving me false positives.
Let’s say I have some entities—Team 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
...