List:General Discussion« Previous MessageNext Message »
From:Andrew Moore Date:October 11 2011 3:19pm
Subject:Re: Beginner question
View as plain text  
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 <biz@stripped> 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=1
>
>

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