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))