>Select ASPNet_Users.UserID, ASPNet_Users.UserName, ASPNet_MemberShip.Password, ASPNet_MemberShip.EMail >from ASPNet_MemberShip inner join ASPNet_Users on ASPNet_Users.UserID = ASPNet_MemberShip.UserID >>
>Select ASPNet_Users.UserID, ASPNet_Users.UserName, ASPNet_MemberShip.Password, ASPNet_MemberShip.EMail, ASPNet_Roles.RoleName >from ASPNet_MemberShip inner join ASPNet_Users on ASPNet_Users.UserID = ASPNet_MemberShip.UserID > inner join ASPNet_UsersInRoles on ASPNet_UsersInRoles.UserID = ASPNet_Users.UserID > inner join ASPNet_Roles on ASPNet_Roles.RoleID = ASPNet_UsersInRoles.RoleID >>