Subject Confused about JOINS, and how to solve the following
Author Richard Mace

I have the current structure:

a list of group Id's, so I can ask firebird for all of the users belonging
to these groups (then pass in the list of group Id's). (but I only want a
user returned once, as it is possible that they are in more than one group
that I am viewing)

a table called users_groups with fields: Id, UserId and GroupId
a table called users, which has an Id field (inteneded to be linked to
UserId above)
a table called groups, which also has an Id field (intended to be linked to
the GroupId above)

I am trying to write a query that will pull back each user, as described
above, and am not sure how to do it?

Could someone point me in the right direction please?



[Non-text portions of this message have been removed]