JP CS Data Query - Left Join 2
Article Index
- JP CS Data Query
- Key Features
- Installation
- Configuration and Usage
- Main Table
- Left Join 1
- Left Join 2
- Ordering and Quantity
- Dynamic Field Mapping
- Join Field Aliases
- Compatibility Fields
- Example - Articles with Categories and Authors
- Example - E-Commerce Products
- JP CS Global Pagination Integration
- Download Key and Updates
- Troubleshooting
- Best Practices
- Summary
- All Pages
Page 7 of 18
Left Join 2
JP CS DataQuery supports a second LEFT OUTER JOIN for more advanced database relationships.
The second join can connect either directly to the Main Table or to the table introduced by Left Join 1.
Enable Left Join 2
Enable this option when information from a third database table is required.
Join Table 2
Select the third database table that should be included in the query.
Join 2 Source Table
Select which existing table should provide the source column for the second relationship:
- Main Table (t0) – Join Table 2 is connected directly to the Main Table.
- Join Table 1 (t1) – Join Table 2 is chained from the first joined table.
Source Table Column
Select the column from the selected source table that should be used for the relationship.
Table 2 - Right Column
Select the matching column from Join Table 2.
When joining from the Main Table, the relationship works as follows:
LEFT JOIN #__join2_table AS t2
ON t0.join2_left = t2.join2_rightWhen chaining from Join Table 1, the relationship works as follows:
LEFT JOIN #__join2_table AS t2
ON t1.join2_left = t2.join2_right