Hey, welcome to the lists, Be mindful that your query is using 2 tables and 'SELECT *'.
On Tue, Oct 11, 2011 at 4:11 PM, Biz-comm <b...@biz-comm.com> wrote: > 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 > b...@biz-comm.com > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=eroomy...@gmail.com > >