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