To Create the Join

This step will merge the SUPPLIER_ADDRESS and COMPANY_DATA into one table.

1. From the Table Operators palette, drag the Join operator onto the canvas.

2. In the Create New Join View window, click All to move both tables to the Selected Tables list.

   Both tables appear in the Preview area and are linked to the join.

3. To edit the type of join, click in the field at the top of the join table and select one of the following options:

   Inner

   Returns only the records in the selected tables that match. For this exercise, use this option.

   Left Outer

   Returns all records in the left table regardless if there are any matches with the right table. When there are no matches, the field is NULL.

   Right Outer

   Returns all records in the right table regardless if there are any matches with the left table. When there are no matches, the field is NULL.

   Full Outer

   Returns the all records from the left and right tables in the merged table. All fields that do not match are NULL.

4. Click OK.

   The root join is added to the canvas and is linked to the two tables. You can now create join conditions for the tables.