AnsweredAssumed Answered

How do I compare the records contained in two identical databases?

Question asked by jayankurian on Mar 12, 2012
Latest reply on Mar 14, 2012 by jayankurian

Hi all,

I do have two identical databases.(ditto). Database A has 12,987 records and Database B has 14,280 records.

What I want to do is, to produce a list of records from Database B those are not contained in Database A.

 

In other words:

Database B has all the records contained in Database A, but need to generate a list of records those are not part of Database A.

 

In my example I should get a list of 1293 records if and when I run a script.

 

I don't mind creating another table called Database C to hold the reocords which generate by running the script.

 

 

THERE IS A UNIQUE FIELD IN THE DATABASE

 

Thank you

Outcomes