Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Dec 22, 2006 01:52 PM by mattbug
Member
36 Points
24 Posts
Dec 14, 2006 10:46 PM|LINK
Hi All,
Is there an easy way to do a database query to list all members that are guests? Thanks alot.
535 Points
146 Posts
Dec 22, 2006 01:52 PM|LINK
thiennhien
Member
36 Points
24 Posts
Filter only guests from database
Dec 14, 2006 10:46 PM|LINK
Hi All,
Is there an easy way to do a database query to list all members that are guests? Thanks alot.
mattbug
Member
535 Points
146 Posts
Re: Filter only guests from database
Dec 22, 2006 01:52 PM|LINK
WHERE aspnet_Users.UserId = aspnet_UsersInRoles.UserId
AND aspnet_Roles.RoleId = aspnet_UsersInRoles.RoleId
AND RoleName = 'Guests'