Utilizing temporary tables via an ODBC connection?

Hello, We (my partner and I) had a situation come up yesterday that we were able to get around, but I'd like input on what the best practice might be. I have a temporary resultset that I'd like to join with another SQL, or use in a subquery in another SQL. FYI - I'm using Microsoft Visual FoxPro, connecting to an IDS v7.3 instance via the current ODBC drivers from IBM. What we ran into was that our initial SQL ended up as a local FoxPro cursor, which of course could not be referenced within another SQL statement sent over the ODBC connection. The solution was to parse the cursor and assemble a new SQL statement with an "WHERE IN (ValueList)" clause. Is there a way to create a temporary cursor on the Informix server that I can reference in other SQL statements via an ODBC connection? Any information would be helpful. Thanks. -- William Fields MCSD - Microsoft Visual FoxPro US Bankruptcy Court Phoenix, AZ "I have no special talents, I am only passionately curious" - Albert Einstein