In my script I first load a table using:
[Table_A]:
Load
field1,
field2,
...
fieldN
from [Path_to_my_excel];
Later I have create a temporary table, let's say, TEMP_TABLE, from [Table_A] and then join TEMP_TABLE with another table.
The result joining table, TEMP_TABLE, has the same columns as [Table_A] but now what I want is to copy entire temporary table TEMP_TABLE into [Table_A], but not append to it, I mean, I want to remove all the records from [Table_A] and copy to [Table_A] the new records from temporary table TEMP_TABLE.
So how to copy all the records from TEMP_TABLE into [Table_A] (not keeping existing [Table_A] records)?
