Re: Need help with MySQL query
| From: | Viorel Dragomir | Date: | Fri, 05 Mar 2004 09:45:00 +0000 |
| Subject: | Re: Need help with MySQL query | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-33323@lists.php.net to get a copy of this message | ||
>
> ----- Original Message -----
> From: "Mikhail U. Petrov" <mikhail@begun.ru>
> To: <php-db@lists.php.net>
> Sent: Friday, March 05, 2004 11:38 AM
> Subject: [PHP-DB] Need help with MySQL query
>
>
> > Hi!
> > I need help with simple mysql query.
> > I have table:
> > program{
> > program_id,
> > partner_id
> > }
> > partner{
> > partner_id,
> > parnter_name
> > }
> > how I can get number of distinct partner_id's where program_id in (
> > bla bla bla)?
>
> select distinct a.partner_id, a.partner_name
> from partner a, program b
> where a.partner_id = b.partner_id
> and b.partner_id in (1, 2, 3)
sorry for the last line...
and b.program_id in (1, 2, 3)
>
> > Best wishes,
> > Mikhail U. Petrov.
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>