Temp Table

[rkiss]

Hello,

I have a query that creates about 30,000 records each time. I would like to dump the results into a temp_table with a timestamp. The query will run once a week and the results will be appended to the temp_table each time with a timestamp

How would I go about creating this temp table?

Thank you for your help

[rkiss]

Let me refrase.

I would like the resuts to be dumped to a table, not a temp table.

Thanks

Roman

[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;

[rkiss]

I would like to insert result to a table from a query. This query looks up information from 3 different tables. So, idealy the results should be dumped into a summary table.

Thanks

[jodie]

Same principle. Just make your select join the three tables.

[rkiss]

I guess what I am after is a procedure that will insert results into the table.

Thanks