请教一个SQL语句

[feng1214]

有个表字段为
GroupID 组编号,UserID 用户编号


怎样查询用户没有加入的组

[JiangHongTao]

select groupid from tb
where groupid not in(select groupid from tb where userid = @id)

[JiangHongTao]

select distinct groupid from tb
where groupid not in(select groupid from tb where userid = @id)

[feng1214]

谢谢

[中国风]

select distinct GroupID from T a where not exists(select 1 from T where GroupID=a.GroupID and UserID='001')


select GroupID from T a where GroupID not in(select GroupID from T where   UserID='001')

[中国风]

楼主有点在倒分哟

[-狙击手-]

select distinct groupid
from Ta a
where not exists(select 1 from ta where userid = a.userid and userid = @userid )

[-狙击手-]

???

[dawugui]

有个表字段为
GroupID 组编号,UserID 用户编号


怎样查询用户没有加入的组
----------------
declare @usrid as int
set @usrid = 某值

select distinct GroupID from tb where GroupID not in (select GroupID from tb where UserID = @userid)

[中国风]

有点像....