Is it possible to run a query against multiple recordsets in memory to build
a another recordset?

I have tried this simple query below as a start and of course it doesnt
work. It says I am referencing a closed connection.

strTmpQuery = "SELECT F10id, F10ddate, F10brk, F12Test, from adoF10,adoF12
WHERE F12Test = F10id"

With adoTmp
If .State = False Then
.Open strTmpQuery
End If
End With

Thanks for any help,