Re: Query as source for query

2002-07-24 Thread Victoria Reznichenko
Publici-Textes, Tuesday, July 23, 2002, 10:40:40 PM, you wrote: PT> In MSAccess, I am able to use a query as a (partial) source for another query. PT> LSelect Names, Department from qrySelectedEmployees, tblDepartment PT> where qrySelectedEmployees.EmplId = tblDepartment.EmplId PT> Is this pos

RE: Query as source for query

2002-07-23 Thread Cal Evans
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 f