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 (I've them still 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,
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 (I've them still 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,