Kevin,

Assuming that you have a relationship on RoleID between aspnet_Roles and RolesToGlobalRoles :

var query = from r1 in DataContext().aspnet_Roles
                        where r1.RolesToGlobalRoles.Any()
                        select r1;

Kurt
>How do I convert this to Linq:
>
>

>
>SELECT r1.*
>	FROM aspnet_Roles r1
>	WHERE r1.RoleId IN
>		(SELECT r2.RoleId
>			FROM mmlaspnet_RolesToGlobalRoles  r2)
>	ORDER BY RoleName
>