>I have two table which they have same structure and fields. One of the table is temp table and the other one is i need. I wish to overwrite the record (they have same of records) the real table by temp table, is it have any cobe to do it ?
>thanks
>
>regard,
>chang
Chang,
This would need an exclusive access to real table. If it's OK you could do it with more than one ways. A simple one :
select RealTable
zap
append from TempTable
Cetin