Re: Newbie: Multiple joins?

2001-02-09 Thread Bob Hall
>Hi there > >the case: >- one table with users (tblUser) >- one table with groups (tblgroups) >- one table with user-group links (tbluserlink) - describes which groups one >user belongs to, in a many-to-many relationship > > >the question: >I want to make a select where I get all the users, that a

Newbie: Multiple joins?

2001-02-09 Thread Henrik Lebtien Mohr
Hi there the case: - one table with users (tblUser) - one table with groups (tblgroups) - one table with user-group links (tbluserlink) - describes which groups one user belongs to, in a many-to-many relationship the question: I want to make a select where I get all the users, that are in the s