Creating a Inner Join by Dragging Columns

To create an inner join between two base tables by dragging columns, follow these steps:

1. Identify the join columns, one from each table. These are the columns to which the join condition is applied.

2. Drag the first join column header on top of the second join column header. The cursor should change to a join symbol, and a green line should appear in the second join column header.

 

3. When you see the join symbol and the green line, drop the column header.

This creates a new table that represents the inner join of the two base tables. A graphical link is drawn between the two join col­umns, and the join type symbol is displayed. By default, the “equal­ity” join condition is used, producing the so-called “equi-join.” For information on changing the join condition or join columns, see Changing the Join Type.

4. If desired, repeat the above steps to implement multiple join conditions.

<< 5.2.1 Inner Join © 1996-2013 InetSoft Technology Corporation (v11.4) Creating an Inner Join with the 'Join Table' Button >>