Progress
Report Builder
User’s Guide


Inner Joins

An inner join is a join that includes only those records that have matching values in both tables. Records from either table that do not have a match in the other table are not included in the report.

Figure 8–1 illustrates how inner joins work.

Figure 8–1: Inner Joins

This example shows which records Report Builder includes when you define an inner join between the Customer and Order tables on the Cust-Num field. The resulting composite table contains only those orders that match the values of the Cust-Num field in the Customer table, and only those customers who have placed orders.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095