Is it possible to use multiple recordset objects in a query?

[Lonnie M.]

I am wondering if it is possible to query two recordsets into another
recordset object. I haven't seen examples of querying an ADO recordset
in the source property of the recordsets open method, but I believe it
is possible. Below is the psuedo code for what I am trying to
accomplish:

rst2.Open _
Source:="SELECT rst1.Fields.Item(1), rstP.Fields.Item(0),
rstP.Fields.Item(1), rstP.Fields.Item(2), rstP.Fields.Item(3),
rstP.Fields.Item(4) " & _
"FROM rst1, rstP " & _
"JOIN Pricing ON rst1.Fields.Item(2) = rstP.Fields.Item(0) " & _
"ORDER BY rst1.Fields.Item(1);", _
Options:=adCmdText

I can create the queries behind rst1 & rstP without a hitch, but I am
running into trouble on figuring out how to build rst2 based on a
query of the recordsets rst1 & rstP.

Thank you in advance, Lonnie M.

 

[Lonnie M.]

Bump... Any takers, your help would be greatly appreciated.

Thanks—Lonnie M.