Overview
In Query Design Window, there is a tab named Query Builder. The database objects are displayed in left panel. To design a query, choose the database object in the list and add to the middle blank area by double-clicking left mouse button or by Drag&Drop. All the objects in the middle area can be moved by Drag&Drop.

After you modified your query through query builder, you can continue to edit it in the SQL editor. You can also execute the query by clicking the "Run" button.

Query Builder Design Panel

Create Join Queries
To associate database objects by two fields, you can choose one of them and drag it to the other field. They will be linked together. If these fields failed to be linked, cursor will look like a forbidding sign. When you drop a field, a line will appear between the linked fields.

Position
Position of designed queries can be saved. Next time, the previous position will be remain unchanged.

Drag & Drop
You can drag and drop a field from field box to Selection Criterion Box or Grouping Criterion Box

Double-Click
If you double-click the field, the field will be inserted to the bottom panel.

Popup Menu
If you Right-click the field box, there are 3 popup menu items:
1. Select ALL
2. Deselect All
3. Unlink Other Tables

Projection

Output Name
Output name will be displayed in the grid of your query result.

Sort
To add a field to the sorting list, please enable the checkbox of the field in Projection Panel

Aggregation
You can set the aggregate functions (SUM, MIN, MAX, AVG, COUNT) for each field.

Actual Field Name
Assumed you opened a table in Query Builder Design Panel, you can click the checkbox of a field in order to add the field to Projection box.

Fields Swapping
You can drag-n-drop a field to swap with another field.

Selection Criterion

You can drag and drop a field from field box to Selection Criterion Box. You can feel free to type the SQL condition statement. It will be embedded in the Where part of your query statement.

Grouping Criterion

You can set them in the same way as the criterions (see above). The conditions you set will be included into the HAVING statement of the current query.

Sorting

You can set the conditions of sorting the query records. To add a field to the sorting list, please enable the checkbox of the field in Projection Panel

To set the sorting order, please change the Sort Order in Sorting Panel

Fields Swapping
You can drag-n-drop a field to swap with another field. The sorting order will be based on the field sequence.