temp query

[Bill]

In Access, can I create a SQL statement, run it and then join another SQL
statement to it? I do not want permanent queries in some cases.

Example:

SELECT f1, f2 FROM table1 (as cursor1)
SELECT f2 FROM cursor1

Something like this. I was able to to do this in Foxpro, but it never was
obvious to me in Access.

Thanks
Bill

 

[Dave - Freedonia]

How would that be different from just using 'SELECT f2 FROM table1'?

The only difference is that you won't have f1 in the resulting recordset.
Unless f2 from table1 is different from f2 in cursor1???

 

[Bill Hicks]

the example I gave was for simplicity.
my question is...can I return a recordset and then base another SQL
statement on the one I just created in memory? temp queries would
accomplish this, but in order to create a temp query you need to create it
with a blank name right? well, at that point I have no way of referencing
it from another on-the-fly query.

anyone following me here?
Thanks

Bill


--