Oops..

I added WHERE UserID = 3 after ON UG.UserGroupID = UGR.UserGroupID and it worked just fine.

Thank you very much! 🙂

Thanks, that's a lot closer then I ever got. However, it returns selected = 1 on all usergroups instead of just two of them.

Added a DISTINCT as well, so now...