For example, if you want to create an Advanced List that includes a user who is a Parent but is also NOT a Teacher (can be used for all roles by updating the filters):

1. Add the Constituent information Objects: User Base, User Role (unless these already exist in your current list) and another User Role
2. User Role object should be a Inner Join (check box should be checked beside the word Inner)
3. User Role [1] object should not be an Inner Join (check box should not be checked beside the word Inner)
User-added image
4. Add the Global Filters User Role.Role Any of ROLE you want the user to be (in the above example this would be Parent) and User Role [1].User ID is NULL
5. Object Filter User Role [1].Role is/Contains/Any of ROLE you do not want the user to be. (in the above example this would be Teacher) How this will look in the Filters List using the example:

Global Filters: 
User Role.Role Any of: Parent
User Role [1].User ID is NULL
Object Filters:
User Role [1].Role is/Contains/Any of: Teacher
User-added image