Users Not Assigned to a Group

[asmall]

I have a list of users that are assigned or not assigned to a group. A user can be assigned to multiple groups.
I am trying to write a query that would show me the groups they are assigned to as well as the groups they are not.
Having trouble with the logic and wondering if anyone could provide some assistance.

See attachment for an example on what I am attempting to accomplish.

 

[johnherman]

untested - it's easier in Oracle due to the Oracle MINUS command.

select a.user, ' in ', a.group from groups_table a -- these are "in"
union
select b.user, ' not in ', b.group from groups_table b
where b.group not in ( -- these are the "not in"
select distinct (c.group) from groups_table c -- these are "in"
where b.user = c.user)



==================================
advanced cognitive capabilities and other marketing buzzwords explained with sarcastic simplicity