• schoenbeck16 (12/9/2016)


    ...

    I don't think this one will work as is, since the variable will only hold the last value selected.

    OK, I thought there was only 1 row in the ROLES table for the role_name Controller. I broke the problem down into figuring out that ID, then excluding the people (WHERE NOT EXISTS) that have that Controller role. How many roles are Controller?