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.id, u.whatever, u...
from users_groups g
join users u on g.userid = u.id
where group_id in (list of groups);

--
Milan Babuskov
http://swoes.blogspot.com/
http://www.flamerobin.org