You can create a normal join using the join condition in a source qualifier. However, if you are creating an outer join, you need to override the default join to perform an outer join. As a result, you need to include the normal join in the join override. When incorporating a normal join in the join override, list the normal join before outer joins. You can enter multiple normal joins in the join override.

To create a normal join, use the following syntax:

The following table displays the syntax for Normal Joins in a Join Override:

For example, you have a REG_CUSTOMER table with data for registered customers:

The PURCHASES table, refreshed monthly, contains the following data:

To return rows displaying customer names for each transaction in the month of June, use the following syntax:

The Integration Service returns the following data:

The Integration Service returns rows with matching customer IDs. It does not include customers who made no purchases in June. It also does not include purchases made by non-registered customers.