Deleted Records?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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)?
 
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
 
Back
Top