Eclipse Community Forums: BIRT » Select INTO temporary table

Home » Archived » BIRT » Select INTO temporary table(Can see result of a query with temp table in preview but not when run as PDF)

Show: Today's Messages :: Show Polls :: Message Navigator

Select INTO temporary table [message #1782310]

Wed, 21 February 2018 15:53

Martin Fafard

Messages: 3
Registered: June 2012

Junior Member

Hi

This is a simplified presentation of a query that I need for a report. I can preview data but nothing when run as PDF. My question: BIRT can "manage" this temporary table ?

With tableA as
(Select field1,field2, field3 from tableB)

select
tableA.field1, tableA.field2, tableA.field3
INTO TEMPORARY tabletemp

from tableX
left join tableA ON fieldX = field1
;

UPDATE tabletemp SET field3 =
(SELECT ...
FROM ...
WHERE ...)
;

--final compute
select min (field1), max ...
from tabletemp;

drop table tabletemp

Report message to a moderator