Subject Re: [firebird-support] Confused about JOINS, and how to solve the following
Author Milan Babuskov
Richard Mace wrote:
>>select distinct userid
>>from users_groups
>>where group_id in (list of groups);
> Yes, I would need a lot more, so would need to use a JOIN, but am still
> learning.
> Could you give me an idea of the syntax please?

select distinct, u.whatever, u...
from users_groups g
join users u on g.userid =
where group_id in (list of groups);

Milan Babuskov