From: Andrew Moore Date: October 11 2011 3:19pm Subject: Re: Beginner question List-Archive: http://lists.mysql.com/mysql/226019 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=000e0cd18332df9ef004af076ff5 --000e0cd18332df9ef004af076ff5 Content-Type: text/plain; charset=ISO-8859-1 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 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 > biz@stripped > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=eroomydna@stripped > > --000e0cd18332df9ef004af076ff5--