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.

 

[Pat Hartman]

If the queries that produce the three recordsets are saved as querydefs, you can create a new querydef that joins the other ones. Are you sure that all three recordsets have exactly the same key data set so that you won't be loosing records because a key is missing from one of the tables?