Hi,

I'm very new in SQL and VBa, so maybe it's very simple, but I'm not being
able to use one or more Recordsets in a SQL SELECT sentence.

Having 2 recordsets (opened) what I need is to relate them in a sql
populating a new recordset....
....
rsOne
rsTwo

ssql="SELECT rsOne!Field1,rsOne!Field2,rsTwo!Field1 FROM rsOne,rsTwo WHERE
rsOne!Field1=rsTwo!Field1"
rsThree.open cnn,,,adcmtext

But this gives me an error saying Microsoft Jet can't find rsOne object.

What I'm doing wrong?

Thanks for your help,