>I have an app that takes lookup table data off a server. The app needs to know what has changed between its old and new set of lookup tables. To do this is throw the old lookup table to lookip.xxx, append the new lookup data into lookup.dbf and then run a sql querry between the 2 for key = key and some information is different. It works fine.
>
>My problem is that the new lookup tables might have new_ records that dont have a match in the old table.
>
>Is there a SQL way of asking if a record in table 1 does not have a match in table 2?
>
>
>TIA
>
>Chris

select a.key, b.key, ;
isnull(a.key) as 'NotInOld', ;
isnull(b.key) as 'NotInNew' ;
from old a full join new b on a.key=b.key

Cetin