st: Using OBDC to reference a Stata file?

[<stata@spandrel.net>]

I'm trying to use Stata to construct tables from a very large database (ie,
terrabytes) using ODBC.  I'm new to SQL, but because of the size of the
database am trying to do as much as I can via the SQL requests to avoid
working with very large files. 

Currently, I am able to create, say, table1.dta which is a list of
identifiers that meet a certain criteria; this results from a very complex
SQL statement that I submit via 

. odbc, exec(`mySQL')  
. save table1

Now I would like to use table1 in my next SQL query so I select only those
identifiers. Possible? 

It seems not, but I feel compelled to ask because the advice I have received
from those who routinely use this database is to use SAS, which will in fact
let me reference SAS datasets in an SQL procedure. I'd prefer not to.

Thanks,
Jeph


*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/