I have three tables `Users`, `UserRoles`, `UserInRole`.

```
Users     UserInRole    UserRole
------    ----------    --------
Id        UserId        RoleId
Name      RoleId        Name
Email 

```

I want to select user emails who is in **"admin"** or **"editor"** role.

```
var emails = userUnitOfWork.Repository.Select()
     .Where(u => u.UserRoles
     .All(r=>r.Name=="admin" || r.Name=="editor")).Select(t=>t.Email);

```

but that only returns one email that has no role.