On Monday, November 18, 2002, at 12:07 AM, OrangeHairedBoy wrote:
Yup, it is.MySQL doesn't support queries inside queries.I think it's on their TODO list...
From <http://www.mysql.com/doc/en/TODO_MySQL_4.1.html>:
--Begin quote--
1.8.2 Things That Should be in 4.1
The following features are planned for inclusion into MySQL 4.1. Note that because we have many developers that are working on different projects, there will also be many additional features. There is also a small chance that some of these features will be added to MySQL 4.0. Some of the work on MySQL 4.1 is already in progress.
* Subqueries.
SELECT id FROM t WHERE grp IN (SELECT grp FROM g WHERE u > 100);
--End Quote--
I also just did a quick search of the list ("the list" being <[EMAIL PROTECTED]>) archive on my computer and got info that subqueries will be in 4.1. Unfortunately, 4.0.x is still in beta.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
