I have a table containing a user id_num and a group_id. The combination of the two fields are the primary key. For example a user may have multiple rows:
So I'm having trouble figuring out my query. I want to return only users with the CD group_id that have no other groupids assigned. So I want to find all CD's who do not have any other groups assigned. Hope that makes sense!