Creating an Inner Join with the 'Join Table' Button
To create an inner join between two base tables, follow these steps:
1. Ctrl-click to select the two table that will participate in the join.

2. Click the 'Join Table' button in the toolbar, and select 'Inner Join'. This opens the 'Inner Join' dialog box.

3. In the top row of menus the 'Inner Join' dialog box, select one column from each table, and choose the join condition that the data must satisfy in order to appear in the result set. The '=' operator produces the “equi-join.” The inequality operators produce their respective “non-equijoins.”
4. (Optional) To convert an inner join to an outer join, select 'include all values' for the left or right table, or for both tables. These selections correspond, respectively, to the left outer join, the right outer join, and the full outer join.
5. Select additional columns and join conditions from the remaining menus in the 'Inner Join' dialog box to create multiple join conditions.
The outer join is a generalization of the inner join: In addition to the matching rows preserved by the equi-join, the left outer join preserves all the rows in the left table, while the right outer join preserves all the rows in the right table. The full outer join preserves all the rows of both tables.
When you specify an outer join, the additional rows included from a table (beyond those selected by the equi-join) do not have matching rows in the other table. Therefore, outer-join tables generally exhibit empty cells corresponding to these unmatched rows.
For information on changing the join condition or join columns after creating the table, see Changing the Join Type.
Suppose you have two queries, 'Salesperson' and 'Sales by Employee'. The 'Salesperson' query returns the names of the sales people and their sales quotas. The 'Sales by Employee' query returns the names of the sales people and the total sales each one of them has made. You can very easily compare their total sales with the sales quota by joining the two tables, each of which is bound to one of the above mentioned queries.

1. Create a new Worksheet by clicking on the 'New Worksheet' button.
2. Expand the 'Data Source' node, then the 'Orders' node, and the 'Order Model' node.
3. Drag the 'Salesperson' entity on to one of the empty cells in the Data Worksheet. A new table, 'Salesperson1' is created.
4. Drag the 'Sales by Employee' query from the tree on to one of the empty cells in the Data Worksheet. A new table, 'Sales by Employee1' is created.

5. Now hold down the left mouse button and drag the 'Last Name' column header from the 'Sales by Employee1' table on top of the 'Last Name' column header of the 'Salesperson1' table. Notice that the cursor changes and a green line is drawn in the destination cell.

Notice that the connector line on the bottom row of the table shows the join relationship by connecting the join columns together.
6. Release the left mouse button to create the join. A new joined table, 'Query1', is created.

7. Preview the 'Query1' table by right-clicking on the title row and selecting 'Preview'.

| << Creating a Inner Join by Dragging Columns | © 1996-2013 InetSoft Technology Corporation (v11.5) | 5.2.2 Outer Join >> |