BIRT - select into temporary table

Migrateduser

Hi

This is a simplier 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