[Fwd: Re: [rt-devel] Getting all groups which a user belong to]
mark at ifl.net
Thu Nov 22 08:47:23 EST 2001
I think this is what you mean ....
Select Groups.Name FROM Groups, GroupMembers, Users WHERE
Groups.id=GroupMembers.GroupId AND GroupMembers.UserId=Users.id AND
Timo Hummel wrote:
>does anybody know a nice method to get out in which groups a user is
>or do I have to query each group on its own for that?
Mark Vevers. mark at ifl.net / mvevers at rm.com
Internet Backbone Engineering Team
Internet for Learning, Research Machines Plc
Tel: +44 1235 823380, Fax: +44 1235 823424
More information about the Rt-devel