Hi Peter.

There's no way to do this, at least that I've come across. I've been faced with similar situations and I have gotten the data I need from the second table, then added the table's fields to the memory-only ADO recordset, then looped through the two recordsets to add the appropriate data.

This requires a design that includes as little data as possible being returned from the data source, of course...

I have also seem folks create temp tables and dump the memory-only rs into the table, and *then* execute a select. And then, of course, clean everything up. Pretty inelegant, but it works.

>Hi,
>
>Is it possible to have create a recordset that joins with other recordsets that only exist in memory?
>
>I have a few recordsets that I have populated with data - they do not exist as tables in a database. I want to build a new recordset that uses a table from my database and needs to join with the memory recordsets.
>
>Is it possible to do this using normal SQL such as "...From Table1 Inner Join Table2..." where Table1 is a physical table in the database and Table2 is only in memory?
>
>Or am I going to have to create my recordsets differently?
>
>Pete