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