JP CS Data Query - Left Join 1

Left Join 1

Left Join 1 allows records from a second database table to be combined with records from the Main Table.

Enable Left Join 1

Enable this option when additional information required by your YOOtheme Pro layout is stored in another database table.

Join Table 1

Select the second database table that should be joined to the Main Table.

Main Table Column

Select the column from the Main Table that contains the relationship value.

Common examples include:

• catid
• created_by
• product_id

Table 1 - Right Column

Select the matching column from Join Table 1. In many Joomla database relationships, this will be an id column.

Conceptually, the generated relationship works as follows:

LEFT JOIN #__join1_table AS t1
ON t0.join1_left = t1.join1_right