Join Type¶
The table below explains the results when different 'Join Types' relationships are used in the example of the customer and orders table. Columns from both the customer table and the orders table are included in the report, which is relevant because relationships to or from a table are ignored when no columns from that table are used in the report.
| Join Type | Description | Result |
|---|---|---|
| Inner Join | Shows all records for which the content of the related fields in both tables are exactly the same. For a DataFlex data source, this is the standard join type! | All customers and their related orders, but NOT customers without orders and NO orders that are not related to a customer. |
| Left Outer Join | Shows all records for which the content of the related fields in both tables are exactly the same AND the records of the main table for which the value of the common field does not exist in the related table. | All customers and all related orders, including customers without orders. |
| Right Outer Join | Shows all records for which the content of the related fields in both tables are exactly the same AND the records in the related table for which the value in the common field does not exist in the main table. This type is not applicable for a DataFlex data source. | All orders and related customers, including orders that are not related to a customer. |
| Full Outer Join | Shows all records of both tables. This type is not applicable for a DataFlex data source. | All customers and related orders, including customers that have no orders and orders that have no customers. |