I am trying to write a query for a web page that shows a list of users in a particular
group.
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
SELECT *
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.
Regards,
Patrice Olivier-Wilson
828-628-0500
http://Biz-comm.com
biz@stripped
