I want to write SQL which can be run on Ingres database. In the SQL, I would like to create temp table to store first SQL result to be used in second sql, to trim SQL performance and tempdb usage.
I know how to write on sybase but not ingres, can somebody please help?
i.e. in sybase, such thing can be done...
select * into #temptable1 from table_A
select * from #temptable1