I have 2 recordsets which I have created dynamically, using ADO disconnected recordsets and the contents of a couple of 2 dimensional arrays, (without connecting to any  database)

Can/How do I run a SQL query joining the 2 recordsets to return a third dynamic recordset?

Jeff Clayton.

*** Sent via Developersdex http://www.*-*-*.com/ ***
Don't just participate in USENET...get rewarded for it!

Hi,

No, you cannot (at least in this version of ADO). ADO does
not support relations between recordsets (ADO.NET will do
it). You need to write some code to synchronize your
recordsets. Check Filter property of Recordset object. It
will help you. When you select record in first recordset
you can filter second one with related records.

Val

using ADO disconnected recordsets and the contents of a
couple of 2 dimensional arrays, (without connecting to
any  database)
return a third dynamic recordset?

There is no way to join two recordsets into one using SQL, using the
current release of ADO. This would have to be done as follows:

1. Open recordset A
2. Open recordset B
3. Create recordset C in code,
4. Using VB, read records from A and B into C.

Sorry I don't have a better answer!

Steven Bras, MCSD
Microsoft Developer Support
Visual Basic WebData

disconnected recordsets and the contents of a couple of 2

Jeff,

Why not use a shaped (hierarchical) recordset?  Then you get the recordsets
in one call, already joined.

Jeff Jones

disconnected recordsets and the contents of a couple of 2

Jeff,

Why not use a shaped (hierarchical) recordset?  Then you get the recordsets
in one call, already joined.

Jeff Jones