In the meantime, you can almost always perform the equivalent of a sub-select using an inner join (and sometimes a temp table). For example, a query to select all customers in the province of Ontario:
SELECT * FROM Customers WHERE CityID IN( SELECT CityID FROM Cities WHERE ProvinceID = "ON" ) Can be re-written as: SELECT * FROM Customers INNER JOIN Cities ON Customers.CityID = Cities.CityID WHERE Cities.ProvinceID = "ON" Hth, Arthur -----Original Message----- From: Stefan Hinz [mailto:[EMAIL PROTECTED]] Sent: February 13, 2003 8:36 AM To: Elby Vaz Cc: [EMAIL PROTECTED] Subject: Re: [ sub select in 4.0.9-gamma? ] Elby, > The MySQL-4.0.9-gamma to windows supports sub select? Nope. Subselect are supported as of 4.1. Regards, -- Stefan Hinz <[EMAIL PROTECTED]> iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php