>My mind is mush! (must be the holidays).
>
>Is there not a one line SQL statement or expression for an APPEND FROM that updates a table with records from another identical table which don't exist in the first table?
>
>Something like....
>
>USE A
>APPEND FROM B FOR B.keyfield NOT EXIST(A.keyfield)
>
>--- Larry
You'll have to do this in two steps:
SELECT * FROM fiest TABLE WHERE Key NOT IN (SELECT Key FROM SecondTable) INTO CURSOR Unmatched
SELECT SecondTable
APPEND FROM DBF("Unmatched")
Erik Moore
Clientelligence