asp.net - sql query for list of all users details in Membership -

i'm using .net membership user management, i'd make page admin lists users details.

the membership system created tables in sql database server , i'm trying info query somehow query returns nothing.

these relevant tables created in server:

i tried query: (ms sql 2008)

select u.username, m.email, m.createdate, m.lastlogindate, r.rolename dbo.aspnet_users u, dbo.aspnet_membership m, dbo.aspnet_usersinroles uir, aspnet_roles r (u.userid=m.userid) , (m.userid=uir.userid) , (uir.roleid=r.roleid) 

but returns nothing, when try:

select u.username, r.rolename dbo.aspnet_users u, dbo.aspnet_usersinroles uir, aspnet_roles r (u.userid=uir.userid) , (uir.roleid=r.roleid) 

it returns table user name , role. guess problem membership table userid field don't know how explain really.

try this:

where (u.userid=uir.userid) , (m.userid=u.userid) , (uir.roleid=r.roleid)