Re: Need help with MySQL query
| From: | Viorel Dragomir | Date: | Fri, 05 Mar 2004 09:42:51 +0000 |
| Subject: | Re: Need help with MySQL query | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-33322@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)
> Best wishes,
> Mikhail U. Petrov.
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>