Filter One Recordset by Another Recordset
Posted on 2006-05-19
I have two ADO recordsets in Access. They have two common fields (say, ID_1 and ID_2). I want the first recordset to be filtered so that it only includes items also in the second recordset. This is not a simple filter (say, ID_1 > 3 and ID_2 > 200), but more involved. I cannot change the original SQL query string that resulted in either recordset. Now, the simple way is to loop through the first and then inner loop through the second, but that is awfully slow for large recordsets. Is there a better way?