Reports that Use Multiple Tables
At times, you must use Report-Writer to produce a report from related information scattered across several tables that share one or more column definitions. You can do this several ways. You can specify the tables in a query in the .query section of your specification. Alternatively, you can build a report on an existing view or you can create a temporary table or view based on multiple tables using query language statements in the .setup section. You can then drop the table or view, or update a status, in the .cleanup section of the same report.
For a discussion and example of joining tables for a report, see the appendix "Report-Writer Report Examples."