I was hoping someone could help me with a query...I am thinking that I need an 'IN' statement, however I am not sure. Here is what my tables look like:

tblGroups
---------
group
---------
groupA
groupB
groupC

tblBridge
---------
user | group
---------
userA | groupA
userA | groupB
userB | groupC
userC | groupA

Basically I want my query to show only the groups that userA is NOT a member of...which is just gorupC. Any ideas?