4 hours trying to do this query

Xyis

Hi, i have spent too long on this now and am getting no where. im going to take a break and come back to it again soon. but just incase someone out there can do this in their sleep i thought i would plea for help...

I have 3 tables.

clubs
--------
cID
cName
cInfo

sponsors
--------
sID
sName
sInfo

club_sponsors
---------
cID
sID


club_sponsors stores which sponsor shows up in which club. What i am trying to do is create a query that will display all the clubs excluding clubs that a perticular sponsor has already been added to.

Any help is much appreciated.

Xyis

Done it, for those that want to know:

SELECT cID, cName
FROM clubs
WHERE (cID NOT IN
(SELECT cID
FROM (SELECT club_sponsors.cID, club_sponsors.sID
FROM (clubs clubs_1 INNER JOIN
club_sponsors ON clubs_1.cID = club_sponsors.cID)
WHERE (club_sponsors.sID = @sID)) derivedtbl_1))