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.
- Related Topics:
- Change Join Types
You can change the join type by selecting the new type from a drop-down list.