Re: Re: Problem whith query in query

From:	Chris Garaffa	Date:	Mon, 18 Nov 2002 05:50:22 +0000
Subject:	Re: Re: Problem whith query in query
References:	1	Groups:	php.general
Request:	Send a blank email to php-general+get-124873@lists.php.net to get a copy of this message

On Monday, November 18, 2002, at 12:07 AM, OrangeHairedBoy wrote:

MySQL doesn't support queries inside queries. I think it's on their TODO list...

Yup, it is. 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 <mysql@lists.mysql.com>) archive on my computer and got info that subqueries will be in 4.1. Unfortunately, 4.0.x is still in beta.