Graphical View: Toolbar

In Graphical View, the toolbar above the workspace gives you additional functionality to create joins and conditions.

Join Type

By default, the tables are joined using an Inner join. When two or more tables are joined, additional Join Type options become available, as well as the ability to enter Query Conditions.

The Join Type field displays the type of join used and allows you to select another type to return different result sets.

Query Conditions

This field lets you create conditions for the current data object in SQL format, except the WHERE keyword. Click next to the field to display a visual condition editor. This lets even users with limited knowledge of SQL specify conditions without writing any SQL code.