How to compare 2 recordsets???
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
Re: How to compare 2 recordsets???
sorry guys i meant:
Rs3= select rs1.Field1,rs1.Field2 from rs1,rs2 where rs1.Field1<> rs2.Field1