Deleted Records?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JHL - 23 Nov 2005 18:31 GMT

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

Reply to this Message

JHL - 23 Nov 2005 19:16 GMT

I forgot to say, Thanks in advance.

> Here’s what I have and did with two tables.
> Have tableA (91K records) that has duplicate records. Created a blank
[quoted text clipped - 4 lines]
>
> How do I get a table of the 50K records (tableA – tableB)?

Reply to this Message

Sunil - 24 Nov 2005 15:30 GMT

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

Reply to this Message