No.
but you can join both table before creating the recordset.

select *
from tableA
inner join TableB
ON tableA.index = tableb.index


>Hi,
>
>I would like to ask if i hv create 2 recordset object, say:
>
>dim db1 as recordset
>dim rs1 as recordset
>dim rs2 as recordset
>dim rs3 as recordset
>
>set db1 = opendatabase("a.mdb")
>set rs1 = db1.openrecordset("TableA")
>set rs2 = db1.openrecordset("TableB")
>
>Can i base on the result of the two recordset rs1 & rs2 , to form another rs3, say:
>
>select rs1.*, rs2.* from rs1, rs2 where rs1.index = rs2.index
>the result should be put into recordset rs3
>
>
>Can i do this? If yes, how?