Kbase P4896: How to create inner and outer joins in Progress Results?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
GOAL:
How to create inner and outer joins in Progress Results?
FACT(s) (Environment):
Progress 8.x
Progress 9.x
Windows
FIX:
Outer joins are joins of two tables where all the records of the first table are retrieved whether or not they have related records in the second table. These joins are referred to in Results as “Complete Relationships”.
Inner joins are joins of two tables where the records of the first table are retrieved only if they have related records in the second table. These joins are referred to in Results as “Partial Relationships”.
The default joins created in Results are inner joins. Outer joins are created by first creating an inner joint and then changing it to an outer join.
1. To create an inner join between the 'Customer' and 'Order' tables:
Query -> New -> Reports -> Select the two related tables in the 'Add/Remove Tables' dialog box -> OK -> Select the fields desired in the 'Add/Remove Fields' dialog box -> OK.
2. To change the inner join created in step 1 to an outer join:
Table -> Relationship Types -> Highlight the text 'Between "Customer" and "Order"' in the editor box of the Relationship Types dialog box. -> OK.
3. To change the outer join created in step 2 back to an inner join:
Table -> Relationship Types -> Deselect the text 'Between "Customer" and "Order"' in the editor box of the Relationship Types dialog box. -> OK.
For additional information, see the section entitled "Changing Table Relationships in Multi-table Queries Progress" in the Progress " Results User's Guide for Windows".