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.