I'm using VB6 with ADO and an Access 2000 database. I have two ADODB recordsets with only one field (MfgCode) in common that I need to combine into one recordset. Does anyone have an example of how to do this? I cannot use a SQL statement to write another query to generate the desired recordset. I need to combine the existing recordsets into a new recordset where the mfgcode fields of the two recordsets match.