I need to compile data from several tables, scan the records, update , delete some and then prepare the data for a report. For me the 

with query as(

select

) 

select * from query 

is not enough.

Tiberiu