List:General Discussion« Previous MessageNext Message »
From:Biz-comm Date:October 11 2011 3:11pm
Subject:Beginner question
View as plain text  
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




Thread
Beginner questionBiz-comm11 Oct
  • Re: Beginner questionAndrew Moore11 Oct
    • Re: Beginner questionJohan De Meersman11 Oct
      • Re: Beginner questionBiz-comm11 Oct