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

[Mark Vevers]

Timo,

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 
Users.Name='username';

Timo Hummel wrote:

>Hi,
>
>does anybody know a nice method to get out in which groups a user is
>added,
>or do I have to query each group on its own for that?
>
>Best regards
>Timo
>
Mark

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