Subqueries are not (yet)working in mysql, they will be implemented in the 4.0.x or is it 4.x which hopefully will be out very soon :-)
so if you are using the 3.23.xxx you have to stick with temporary tables /Christian ----- Original Message ----- From: "Larry Reiter" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, December 20, 2001 7:58 PM Subject: Nested Queries. > I have constructed a query which requires a temporary table but I > would rather use a nested query. In other words, I want to extract a > set of data and then use that set of data as a query against some > other data. Like some sort of SELECT within a SELECT. Can I do this > in MySQL? > > Cheers, > > LTR > -- > Dr. Lawrence T. Reiter > Postdoctoral Fellow > Department of Biology, UCSD > Bonner Hall Room 4221 > 9500 Gilman Drive > La Jolla, CA 92093-0349 > > Phone: (858) 534-0442 > FAX: (858) 822-2044 > http://homophila.sdsc.edu > email: [EMAIL PROTECTED] > > --------------------------------------------------------------------- > 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
