Inner Join Tab
You can use the Inner Join tab to define an inner join. Inner joins return only a subset of rows from the left-hand table that matches rows from the right-hand table. The Inner Join tab contains the following elements:
Left side - Specifies the table used for the left side of the join.
Join type - Enables you to select a different join type.
Right side - Specifies the table used for the right side of the join.
Switch sides - Enables you to switch the tables from one side of the join to the other. The table on the left side moves to the right side, and the table on right side moves to the left side.
Define filters - Specifies that filters are defined in the join.
Add parenthesis - Adds a parenthesis around the join in the SQL code.
The Filters section of the tab contains a toolbar that enables you to perform the following functions:
- Auto-generating the default filters for the join (based on the selected tables and the join type)
- Adding, editing,and deleting filters in the filters table.
- Grouping and ungrouping filters
- Moving filters up and down
The filters table contains the following elements:
Boolean - Specifies Boolean values for the filter. Click the drop-down menu to display the available values. The only value displayed for the first filter is NOT. All subsequent filters display AND, OR, AND NOT, and OR.
Open Parenthesis - Adds an opening parenthesis to the filter.
Operand - Enters operands on both sides of the filter operator. Click the drop-down menu to display the available values Select Field displays the Select Field dialog, which enables you to select fields from the source and target tables for the join. CASE displays the Case tab , which you can use to create a case expression for the clause. Subquery adds a select * from
statement to the operand, where you can develop a subquery that you can nest in the join. Expression displays the Expression tab, which enables you to create complex filters.
Operator - Adds an operator to the filter. Click the drop-down menu to select from the following values: =, <>, IN (,), NOT IN (,), >, >=, <, <=, BETWEEN, NOT BETWEEN, EXISTS, NOT EXISTS, IS NULL, NOT IS NULL, CONTAINS, NOT CONTAINS, LIKE (Matches pattern), and NOT LIKE (Does not match pattern).
Close Parenthesis - Adds a closing parenthesis to the filter.