>What's the best way to get items from a second table that do NOT match records from the first one using a query? This is obviously useful when calculating differences in tables. Most people still say that needs to be coded, what's your thought on this?
>
>TIA
>
>Gil
If you mean duplicate check between two tables with same structure then I would do a union and find recs having cnt(*)>1 based on a combined key (not PK).
Cetin