Temp Table

[jodie]

Create the table the first time using:

create table table_b as select x,y,z from table_a;

Then append to it using:

insert into table_b select x,y,z from table_a;