Selecting Multiple Values from Same Coulmn I want a query to find out who doesn't have a specific role (user, create or admin)  

DB is Structured as Follows:

name_last | name_first | role


Sample Data:

brown | john | user |
brown | john | create |
brown | john | admin |
house | chris | user |
brady | bill | user |
pink | deb | user |
pink | deb | admin |
green | ashley | user |
green | ashley | create


Who doesn't have the create role?

select name_last, name_first, role
where role != ??
You can use a not exists query:

select distinct t1.name_last, t1.name_first
from the_table t1
where not exists (select *
                  from the_table t2
                  where t1.name_last = t2.name_last
                    and t1.name_first = t2.name_first
                    and t2.role = 'create');


The NOT EXISTS operator returns "true" if the sub-select returns nothing. In this case the sub-select looks for any row with the same name as the outer row but with the role create