I have this
scenario:

```
class User
{
Id,
UserName
}

class UserRelationship
{
User GroupUser,
User MemberUser
}

and query

var query = QueryOver.Of<UserRelationship>()
.JoinqueryOver(x=>x.MemberUser)
.Where(x=>x.UserName == "TestUser");

```

Now I want to return List Distinct User, so I cannot do 

> 
> TransformUsing(Transformers.DistinctRootEntity)
> 
> 
> 

because this will give me the UserRelationship.

I need something like this:

```
Select distinct user.ID 
from UserRelationship relationship
inner join User user on user.ID = relationship.MemberUser_ID

```

Please help
thanks