Check the manual at www.mysql.com. Use your first query to create a temporary table. Then use your temporary table as a source for additional queries. The tem table will be destroyed when your session is terminated. (Handy if you are piping in several SQL statements from the command line.
For future reference: (Not said in an ugly, or haughty tone, just stating a fact here, with a smile on my face) For the most part, comparisons of Access and MySQL are invalid (as in this one) because MySQL is a database engine whereas S Access is a desktop database. Thee are many things you can do in Access that you won't be able to do in MySQL. HTH, =C= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -----Original Message----- From: Publici-Textes [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 2:41 PM To: [EMAIL PROTECTED] Subject: Query as source for query Hi, In MSAccess, I am able to use a query as a (partial) source for another query. «Select Names, Department from qrySelectedEmployees, tblDepartment where qrySelectedEmployees.EmplId = tblDepartment.EmplId» Is this possible with MySQL? If so, how is it implemented? Thanks for your help. Alain --------------------------------------------------------------------- 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
