Creating and Deleting Join Conditions

Applies to: Kyvos Reporting

Performing Joins

A SQL Join clause combines columns from one or more tables based on a related column between them. Joins are used to retrieve data from multiple tables in a single query and can result in a virtual table, which you can save or use directly in your report design.

You can create joins in SQL Designer using the Diagram Pane. To create a join:

1. Select the required field from the Field List of a table.

2. Drag the field and drop it onto the related field in another table.

3. When the cursor changes to a join symbol, release the mouse button.

An arrow will appear between the connected fields to indicate the join.

Open

Auto-Creation of Joins

Kyvos Reporting can automatically create a join between two tables if:

• A Primary Key – Foreign Key relationship exists in the database.

• The Enable Autolink Foreign Key option is selected under Options > Custom Design.

In such cases, the corresponding join condition is automatically added to the WHERE clause in the generated query.

Removing a Join

To delete a join condition:

1. In the SQL Parser pane, locate the join condition under the WHERE clause.

2. Select the join condition.

3. Press Delete.

The join will be removed from both the Diagram Pane and the WHERE clause of the query.

Open