SELECT U.Username, U.Firstname, U.Lastname, R.Rolename, AM.Email
FROM Users U
INNER JOIN UserRoles UR on U.Userid = UR.Userid
INNER JOIN Roles R on UR.Roleid = R.Roleid
INNER JOIN Aspnet_users AU on U.Username = AU.Username
INNER JOIN Aspnet_membership AM on AU.Userid = AM.Userid
WHERE R.Rolename = 'Registered Users' 

Step 2 - As part of my query I wanted to include the Address, City, State and Zip of my registered users.  However, I'm unable to locate this data in my tables.

Step 3 - I would like to make the user name a link and redirect the user to the appropriate profile page when clicked.

Any assistance is appreciated.  Thank you.