[PHP-DB] Need help with MySQL query

2004-03-05 Thread Mikhail U. Petrov 
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

2004-03-05 Thread Viorel Dragomir 

- 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

2004-03-05 Thread Viorel Dragomir 




 
 - 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

2004-03-05 Thread Mikhail U. Petrov 
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