Re: Stand Alone Recordsets

Ilanio wrote:
Hi, I'm using stand alone recordsets to manipulate data without a
database.

Ths sounds like an oxymoron. Are you really opening a recordset on a
database table then setting its activeconnection property to nothing to
disconnect it?

I have two stand alone

Again, please define "stand alone"

recordsets (recordset 1 and recordset 2) and
the data of these recordsets came from different sources.

These recordsets have some coincident fiedls (like name, gender,
etc.).

These recordsets have some data that are equal (duplicated) that I
need to find and show.

I'm trying to show these duplicated data using a third recordset
(stand alone of course) with a SQL query that uses INNER JOIN clause
from fields of the recordset 1 and recordset 2.

Is this possible?

No. You need a database engine to execute sql statements. None exists in
this situation. You will need to run nested loops.


--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Relevant Pages
Loading