Temp Table

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

Let me refrase.

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

Thanks

Roman

Create the table the first time using:

Code:

---

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

---

Then append to it using:

Code:

---

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

---

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

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

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

Thanks