How to join aspnet_Profile and aspnet_Users and get usable data.

[RedEye]

Hello,

The question I have is has anyone created a stored procedure which joins the
aspnet_Profile and aspnet_Users table and provides usable data.

The problem I have is in each users profile they are associated with a
predefined group of users. I would like to have a query that would allow me
to filter the users list based on this profile attribute or any other
profile attribute for that matter.

To me this sounds like a reasonable request and maybe MS already has a
stored procedure to do this. Any help would be appreciated.

Thanks,
Bryan