temp query

  • Thread starter Thread starter Bill
  • Start date Start date
B

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
 
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???
 
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


--
 
Back
Top