Query Question 2

[Ernestw]

I have two tables that should have the same records. However, that is not the case. The common field is part_SN. I should like to run a query that selects the records from table 1 that are not in table 2. I built a SQL statement, but it is incredible slow.

TIA,

Ernie

 

[Snah]

ernie,

try this query

Query
ANSWER: RIV:ANSWER.DB

table1.db | partSN |
| _join1, count=0 |

Table2.db | partSN |
| Check _join1! |

EndQuery

hope this helps
hans

 

[Ernestw]

Hans,

Thank you. Your suggestion works fine.

Ernie