>>>Any other suggestions, please? TIA.
>>
>>insert into (CA.Alias) (field1, field2, ...) select field1, field2, .. from (CA.Alias)
>
>You just beat me to the solution. I just thought about exactly the same and tried to update my initial message when I realized that someone must be posting reply to mine. I think what you suggest will works. Thank you very much.
You're welcome.
If it's not broken, fix it until it is.
My Blog