- On the Join dialog box, click on INPUT .
-
Click on expert options.
Join > Input > Expert Options
This screen provides the option to generate a SQL WHERE clause(s) to restrict rows selected for analysis (for example, cust_id > 0).
It may be useful to note that if a WHERE clause condition is specified on the “inner” table of a join (i.e., a table that contributes only matched rows to the results), the join is logically equivalent to an Inner Join, regardless of whether an Outer type is specified. In a Left Outer Join, the left table is the “outer” table and the right table is the “inner” table.