Impromptu Report with Nested SQL

[swen17]

Hi,

I'm trying to create an Impromptu report (Series 7) that would look something like this:

a.name, a.start_time, a.end_time
b.session, b.actual_start, b.timestamp
c.table_instance, c.table_name, c.success_rows
b.session, b.actual_start, b.timestamp
c.table_instance, c.table_name, c.success_rows
c.table_instance, c.table_name, c.success_rows
c.table_instance, c.table_name, c.success_rows
a.name, a.start_time, a.end_time
b.session, b.actual_start, b.timestamp
c.table_instance, c.table_name, c.success_rows
c.table_instance, c.table_name, c.success_rows
b.session, b.actual_start, b.timestamp
c.table_instance, c.table_name, c.success_rows
c.table_instance, c.table_name, c.success_rows
c.table_instance, c.table_name, c.success_rows

Where each row "a", can have multiple "b" rows, and each "b" row can have multiple "c" rows. I'm having a difficult time accomplishing this and would appreicate any advice or assistance you can offer.

Thanks,
Swen