[Fwd: Re: [rt-devel] Getting all groups which a user belong to]

Mark Vevers 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?
>Best regards

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 mailing list