Joining recordsets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You need to write the recordsets to temporary tables, and then write SQL
statement that uses those temporary tables.
 
Back
Top