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@ifl.net / mvevers@rm.com
Internet Backbone Engineering Team
Internet for Learning, Research Machines Plc
Tel: +44 1235 823380, Fax: +44 1235 823424