Subject | Finding Duplicate teams |
---|---|
Author | Ian A. Newby |
Post date | 2007-08-07T11:27:11Z |
Hi Folks,
An interesting SQL question...
I have two tables, teams and team_members.
for the sake of argument, these are the structures.
team {
team_id
team_name
)
team_members (
team_id
user_id
)
What I want to do is find any teams which have the same members as
another team...
I think I could do it using 2.1 with the new list operator but
unforunately, I'm using 2.0.
Any ideas?
Regards
Ian Newby
An interesting SQL question...
I have two tables, teams and team_members.
for the sake of argument, these are the structures.
team {
team_id
team_name
)
team_members (
team_id
user_id
)
What I want to do is find any teams which have the same members as
another team...
I think I could do it using 2.1 with the new list operator but
unforunately, I'm using 2.0.
Any ideas?
Regards
Ian Newby