Request for help - Querying recordsets as if they were tables

[gellerche]

I have a function that takes three recordsets as arguments. I would like to create a recordset from these recordsets where the PKs match. Something like:

SQL = "SELECT * FROM rs1 WHERE rs1("PK") = rs2("PK") "
SQL = SQL + "AND rs2("PK") = rs3("PK")"

I've read this forum, and have not found a definitive answer, except for one mentioning "disconnected recordsets". Does anyone either know how to do this, or how I can find more about "disconnected recordsets"?

Thank you for your help,


Steve Geller

 

[MikeAngelastro]

You must add a join.