Create and insert into temporary table
Dear all,
I want to create an temporary table and insert data from select statement and order data by field in that table, at the end i want to drop temporary table.
CURSOR rob_twin
IS
SELECT t.tarj, s.b24, date, status, fii, acnt, mbr, pviv, type
FROM
p6.tarj t
p6.stb24 s
p6.cuet c
WHERE .......
--now I want to create table and insert above data (from cursor rob_twin)
--after that I need to order data by t.tary from new table
--finally I want to drop this table
Thank you for your help.
Regards,
Robert