I am trying to write a query for a web page that shows a list of users in a particular
There are 3 tables:
pm1_users that uses UserID
pm1_groupsubscriptions that uses UserID and GroupID
pm1_mailingroups that uses GroupID
So I want to show all the users that belong to a specific mailingroup
FROM pm1_groupsubscriptions, pm1_users
WHERE GroupID = 10
(10 = one of the mailingroups)
That isn't enough to get there. That shows all uses.
Thanks for any assistance.