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 |