Joining Multiple Tables

You can combine the data from multiple tables into a single report. For example, you might want to write a report that displays the details of all open incident records, and also the contact information of the contacts who reported the incidents. The probsummarym1 table contains all the incident details, but contains only the name and phone number of the contact. Additional information about the contact is in the contactsm1 table. A join between the two tables allows you to create a report containing information about the records from probsummarym1 and the detailed contact information from contactsm1 in a single report.