Joining recordsets

M

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
 
K

Ken Snell [MVP]

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