Jim,
Great great tip, it works like a charm.
Thanks,
Gil
>>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
>Gil,
>
>
>
>SELECT * FROM TableB WHERE TableB.PK NOT IN(SELECT PK FROM TableA) ...
>
>
For every bug fixed, there is a bigger bug not yet discovered.