----- Original Message ----- 
From: "Mikhail U. Petrov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to