Follow-On Topics

Related Topics

# About the Tables & Joins Pane

The Tables & Joins section displays the tables within the query and the relationships (joins) between them.

Automatic Table Selection

When selecting columns from the schema on the left, the table from which the column is selected is automatically selected and displayed in the Tables & Joins area. In the case of selecting a formula column, all the tables associated with the formula column are added to the query. When tables are selected automatically, no table is selected more than once.

Manual Table Selection

Tables can be added to the query manually to create more complex queries where intermediate tables are required or where table aliasing is required to relate a table to itself.

Adding a Table

1. Right-click on the Tables & Joins section and select Insert Table from the context menu. The Available Tables dialog is displayed.

2. Select the table you wish to insert and press OK.
3. If the table is already present in the query, the Table Alias dialog is displayed.

   1. Enter a name to alias the table that does not match a table name in the schema or an existing table alias.
   2. Press OK

The table is added to the Tables & Joins Pane.

Removing a Table

1. Right-click on the table title bar.
2. Click Remove on the context menu.
3. If the table has been added automatically by selecting fields and the fields still remain in the query you are warned that you cannot remove the table.
   1. Press OK.
   2. The table is not removed (End.)

The table is removed.

Manual Join Creation

If Joins are not being created automatically or the joins that are created are not suitable, the joins can be created and maintained manually.

Creating a new simple (inner) Join

1. Drag the column in the first table to the column in the second table.
2. If the two columns are not of the same type, a warning is displayed advising the user.
   1. Press Yes to proceed.

The join is shown between the two tables.

Creating a new outer Join

1. First create a new simple (inner) join as described above.
2. Right-click on the join itself and select Join Type from the context menu.
3. Select the type of join required and press OK.
4. If an outer join option was selected, it is displayed with a specified direction.

Creating a formula Join

Usually a formula join is essentially still a join between two columns but with some manipulation, data type conversion or formatting involved. In this case, the quickest method of creating the formula join is to create the basic join first using one of the methods described above and then convert it to a formula join to make the adjustments. Alternatively, you can drag the Formula column from one table to another to create a new empty formula join.

1. Create the basic join using one of the methods described above
2. Right-click on the join itself and select Convert To formula from the context menu. The Formula Editor dialog is displayed, pre-populated with the formula that describes the basic join.
3. Make the necessary adjustments to the join expression noting that the expression must be a logical expression (returns true or false).
4. Press OK.

The Formula Join is displayed.

Removing a Join

To remove a Join from the Query:

1. Right-click on the Join
2. Click Remove from the context menu.

The Join is removed.

Copyright © 2018 Quadrant Software B.V. All rights reserved.