Graphical Query Builder
How does it work ?
The Query Builder is a simple and efficient way to graphically edit complex queries.
The Query Builder uses diagrams for user interaction, similar with the Layout Pane.
But this time the lines between tables are representing the JOIN conditions between tables, namely one of
INNER JOIN, OUTER JOIN, EXISTS and NOT EXISTS.
The EXISTS and NOT EXISTS will be mapped in the proper Sql syntax.
The columns listed by the query are the one which has the checkbox checked.
Aggregate functions and ordering clauses can also be used. They will be listed on the bottom of the table.
New tables can be added to the Query Builder by dragging them from Layout or Tree Pane,
or by pressing one of the active 
icons
at the end of the column name.
Filter and order data
To restrict the displayed records to the one which fullfills a given criteria, set column or table filters.
They are similar with the WHERE clause used in the SQL statements.
The filters dialog is available from the column pop-up menu.
See the generated SQL query
You can view the SQL by pressing the SQL button in the Query Builder toolbar. You can
keep the view open while you work in the Query builder.
