Query members that is not included in a group.

[winsonlee]

Name clubID
Sam 1
Mathew 1
Jason 1
Clues 1
Sam 2
Jason 2

How can i query in such that members that is not in clubID 2 is listed ??
eg :

Name clubID
Mathew 1
Clues 1

[eralper]

Hi,
you can use the below query


select *
from ClubMembers
where
name not in (
select name from ClubMembers where clubID = 2
)

Eralper
http://www.kodyaz.com