RE: [PHP-DB] MySQL Subquery problems...

2005-03-30 Thread NIPP, SCOTT V \(SBCSI\)
ssage- From: Bastien Koert [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 30, 2005 9:35 AM To: NIPP, SCOTT V (SBCSI); php-db@lists.php.net Subject: RE: [PHP-DB] MySQL Subquery problems... only mysql 4.1+ supports subqueries..if you version is lower it won;t work Bastien >From: "NIPP, S

RE: [PHP-DB] MySQL Subquery problems...

2005-03-30 Thread Bastien Koert
only mysql 4.1+ supports subqueries..if you version is lower it won;t work Bastien From: "NIPP, SCOTT V (SBCSI)" <[EMAIL PROTECTED]> To: Subject: [PHP-DB] MySQL Subquery problems... Date: Wed, 30 Mar 2005 09:25:36 -0600 I am working with one of our Oracle DBAs to have him

[PHP-DB] MySQL Subquery problems...

2005-03-30 Thread NIPP, SCOTT V \(SBCSI\)
I am working with one of our Oracle DBAs to have him try and help me get a couple of queries working. The problem is that in looking at the documentation for MySQL it seems that what we are attempting should work. Unfortunately, it doesn't. Here is what we are trying... mysql> SELECT CP