From: Dan Nelson
Date: April 25 2003 5:29am
Subject: Re: crash in mysql 4.1.0 EXPLAIN w/ subquery
List-Archive: http://lists.mysql.com/mysql/138349
Message-Id: <20030425052916.GJ45035@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Apr 25), Vinay said:
> I alway thought that MySQL does not support nested select staments, then how come you are running queries like these
> "EXPLAIN SELECT COUNT(*) FROM table1 WHERE name1 = ( SELECT name2 FROM table2 WHERE id=1 );"

4.1 supports subqueries, although not flawlessly yet :)
http://www.mysql.com/doc/en/Nutshell_4.1_features.html

-- 
	Dan Nelson
	dnelson@stripped