>>>Hi Claude
>>>>1. Why does table Tx have fewer records then table x?
>>>
>>>The original table has deleted records. So, they are not missing. You can use count function to see how many active records are in the original table.
>>>I bet you will have the very same number with select statement
>>>
>>>>2. What is the best way to find what records are missing?
>>>
>>>DO you need deleted records too?
>>
>>I think so. It would be the safest way to go.
>
>Then I would COPY FILE instead of using SELECT.

I used select because the file is on a shared server and is being used. Can I sill use COPY FILE?