I have a SQL query question that I'm hoping someone can point me in the
right direction on.

I have two main tables, and a join table. The tables are as follows:

USER_ACCOUNT
USER_GROUP
USER_GROUP_MEMBERSHIP

I need to find all the USER_GROUPS that a USER_ACCOUNT is NOT a member of.

This is simply for each USER_GROUP that does not appear referenced in the
USER_GROUP_MEMBERSHIP table for the USER_ACCOUNT.

What is the best way to approach a query like this?

Myles

===========================
Myles Wakeham
Director of Engineering
Tech Solutions USA, Inc.
Scottsdale, Arizona USA
www.techsol.org
Phone +1-480-451-7440