Hi there,
AFAIK, there is no (easy) way to merge two Recordsets in ADO. You could do some complicated stuff by using AddNew on the first Recordset to add each record from the second Recordset. However, I think that will kill performance.
If you are able to get your data as ready as can be from the database (filtered, sorted, whatever), you could use the GetRows method of the Recordset to get your data from the Recordsets in a two-dimensional array. You can then merge these two arrays, and do some client side data manipulating (skipping duplicate records, sorting, whatever). Again, this won't be very fast, unless you're working with relatively small datasets.
I take it there is no way to merge the data in the database, so your ASP pages can retrieve data from just one connection? You could look into linking servers or databases to get your data from a single source. For example, in SQL Server, you may get away by using a UNION on two queries that retrieve data from two databases / SQL Servers.....
Hope this helps a bit,
Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.