Onereetourf
New Member
I'm sure there is a proper word for this which I fail to remember, but the problem is easy to describe:I have a table groupmembers, which is a simple relationship between groups and members:\[code\]id | groupid | memberid1 | g1 | m12 | g1 | m23 | g2 | m14 | g2 | m25 | g2 | m3\[/code\]Above describing two groups, one with m1 and m2 and one with m1,m2 and m3.If I want to select groupids which has members m1,m2 but no other members, how do I do it? The approaches I have tried would also return g2, as m1 and m2 is a subset of them.