Ability to query on role field contains user with specific group membership

[Kalaveshi, Adrian]

Hello --

I've been racking my brains all morning trying to come up with a SQL query
to give me a list of bugs who's "assigned_to" value is equal to a member of
group "x".  I know that this probably isn't the proper forum, but I was
hoping that one of you SQL experts might be able to help me out.

FYI, I also filed a bug so that this might become a feature.
http://bugzilla.mozilla.org/show_bug.cgi?id=230225

select
bugs.bug_id, profiles.login_name
from
bugs, profiles
...

Thanks for any help...

-adrian-