----- 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