Deleted Records?

[Guest]

Here’s what I have and did with two tables.
Have tableA (91K records) that has duplicate records. Created a blank
tableb from tableA structure and made primary keys on selected fields.

Appended tableA to tableB. TableB now has unique entries, about 41K records.
TableA is still intact.

How do I get a table of the 50K records (tableA – tableB)?

 

[Guest]

I forgot to say, Thanks in advance.

 

[Guest]

hi

try this query

SELECT TableA.ID, TableA.NAME
FROM TableA LEFT JOIN TableB ON TableA.ID = TableB.ID
WHERE (((TableB.ID) Is Null));

pls let me know if it helps u

Thanx

With regds

Sunil.T