Progress
Report Builder
User’s Guide
Join Considerations
When you are defining joins, consider the following issues:
- If you specify a right outer join, you cannot specify any other joins.
- If you have already specified one or more joins, you cannot define subsequent joins as right outer joins.
- Regardless of how many joins you specify, Report Builder processes the joins from left to right. For example, when you join Table A to Table B to Table C, Report Builder selects records from tables A and B. Report Builder then takes that composite table and joins it to Table C. If the A-to-B join is an inner join and the B-to-C join is a left outer join, the composite table will not really include all records from Table B because they might have already been eliminated by the A-to-B join.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |