您需要的是简单的codd的关系划分。
select distinct p.team from player p
where not exists
(select * from player p1
where not exists
(select * from player p2
where
p.team=p2.team
and
p2.gid=p1.gid))
mysql中的关系划分没有聚集功能?
您需要的是简单的codd的关系划分。
select distinct p.team from player p
where not exists
(select * from player p1
where not exists
(select * from player p2
where
p.team=p2.team
and
p2.gid=p1.gid))