Click the Build Query button
The Query Builder opens in a new window.
The main window can be divided into the following parts:
The Query Building Area is the main area where the visual representation of query will be displayed. This area allows you to define source database objects and derived tables, define links between them and configure properties of tables and links.
The Columns Pane is located below the query building area. It is used to perform all necessary operations with query output columns and expressions. Here you can define field aliases, sorting and grouping, and define criteria.
The Query Tree Pane is located to the left of the query building area. Here you may browse your query and quickly locate any part of it.
The Table List Pane is located to the right of the query building area. It contains a list of all the tables available for query building.
The page control above the query building area allows you to switch between the main query and sub-queries.
The small area in the corner of the query building area with the "Q" letter is the union sub-query handling control. Here you may add new union sub-queries and perform all necessary operations with them.
* Note, when opening the query builder with an existing sql statement it cannot always show a graphical representation of the SQL Statement. If the query was originally created with the query builder it will likely show the graphical representation without errors. However if the query was not originally created by the query builder and it is very complex or contains sql that does not conform to the general ansi92 sql syntax, it may not be displayed. Another cause for a query to not be shown graphically is if the cdd has the option "Enable CONNX Database Catalog Support" checked, which means it is looking for three part table names. If the sql only uses one part table names it will not be able to be displayed.