[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)? Best wishes, Mikhail U. Petrov. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Need help with MySQL query
- 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
Re: [PHP-DB] Need help with MySQL query
- 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) 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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 [EMAIL PROTECTED] VD To: [EMAIL PROTECTED] 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, Mikhailmailto:[EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php