I have sql select for which I want write criteria. I was googling some time, but cant find anything for "not in".
My sql query:

```
select * from users where username not in(
select users.username from users right join authorities on users.username=authorities.username 
where authority='ROLE_ADMIN')  

```

Thanks a lot in advance.
Regards,
Mat