Joining recordsets

[Marty]

Howdy All,

Quick question: if you have a two recordsets that you've defined in
memory (i.e. no connection to a database file), can you join the recordsets?
The only way that I know to do joins is by using SQL, but SQL seems to
require table names.

I guess another way to ask the question would be to ask if a recordset
created in memory could be given a table name.

Thanks!
Marty

 

[Ken Snell [MVP]]

You need to write the recordsets to temporary tables, and then write SQL
statement that uses those temporary tables.