Query issue in ASPNETDB

Hi all!

 This is my first post in this forum. I've read many times before I decided to post because my poor english, so please foregive me if there is too many errors.

---

 I'm trying to write a SQL statement against the ASPNETDB.MDF to retrieve the users and his/her roles. What I need is:

LoweredUserName FROM aspnet_Users 

LoweredEmail FROM aspnet_Membership

RoleName FROM aspnet_Roles

* Users only have one Role.

** I need to use queries directly instead membership provider because I'm using custom paging with an object datasource.

So I've tried this:

SELECT aspnet_Users.UserName, aspnet_Membership.Email, aspnet_Roles.RoleName
FROM    aspnet_Roles INNER JOIN
              aspnet_Membership INNER JOIN
            ...