Hi guys
Well I have done the following:

Set db=dbEngine.OpenDatabase(database)
Set rs1 = db.OpenRecordset( SQLquery1,dbopendynaset)
Set rs2 = db.OpenRecordset( SQLquery2,dbopendynaset)

Now I have 2 recordsets with the same fields now I want to have rs3 as following

Rs3= select rs1.Field1,rs1.Field2 from rs1,rs2 where rs1.Field1<> rs1.Field2

The main idea of this query is to obtain records in rs1 which does not exist in rs2. now my problem is that I don’t know how to use a SQL query for 2 different recordsets that I have created while runtime can anybody help?
Thank u