I posted an earlier question about joining two seperate tables but I think an easier way to ask the question is, Can I create to recordsets and then query them in VB?

Example:

Dim DB as database
Dim db2 as database
Dim Rc as recordset
Dim Rc2 as recordset

Set DB = opendatabase(C:\DATA1.mdb)
Set db2 = opendatabase(C:\DATA2.mdb)

set rc = db.openrecordset(SQLStatement)
set rc2 = db2.openrecordset(SQLStatement)

Now can I join, then at this point??????