I have the following situation where I create an ADO recordset in memory
Now I would like to create a similar recordset, call it rs2, and add records to it. Both have an integer field which I would like to use to join the two sets together.
(Think of a classical SQL statement SELECT TblA.TextField, TblB.TextField FROM TblA INNER JOIN TblB ON TblA.IntField= TblB.IntField ).
Remember I don't actually have any tables, just two recordsets constructed in memory.
So is it possible? and if so how?