Re[2]: [PHP-DB] Need help with MySQL query

Hi! Sorry for disturbing, but, at first, this solution isn't right and, second, I have solved this problem yet. "count (distinct blablabla)" is turned to be right. But thanks... Hello Viorel, Friday, March 5, 2004, 12:42:51 PM, you wrote: VD> ----- Original Message ----- VD> From: "Mikhail U. Petrov" <mikhail@begun.ru> VD> To: <php-db@lists.php.net> VD> Sent: Friday, March 05, 2004 11:38 AM VD> 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)? VD> select distinct a.partner_id, a.partner_name VD> from partner a, program b VD> where a.partner_id = b.partner_id VD> 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 >> -- Best regards, Mikhail mailto:mikhail@begun.ru