Progress
Report Builder
User’s Guide
Right Outer Joins
A right outer join is a join that includes all the records in the related table regardless of whether there are any matching records in the controlling table. Report Builder includes all the records in the related table and any records from the controlling table that match the related table join field.
Figure 8–3 illustrates how right outer joins work.
Figure 8–3: Right Outer Joins
![]()
This example shows which records Report Builder includes when you define a right outer join between the Customer and Order tables on the Cust-Num field. The resulting composite table contains all the records from the Order table and records from the Customer table for which there are corresponding customer orders. Since the composite record contains fields from both tables, when there is no matching order table record, Report Builder fills in the order fields with UNKNOWN values. Notice that there are still two composite records for customer number 2 because there are two orders for that customer in the Order table. However, there are no records for customer numbers 3 and 4.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |