Query Editor Help

Valentina Studio provides a visual Query Editor tool (previously called Visual Query Builder). It allows you to create and edit queries without any knowledge of SQL. You can also immediately execute the SQL that you generate and display the results. Valentina Studio Query Editor can be an excellent tool for learning SQL syntax.

You can decide if you want to build queries through visually dragging and connecting objects, or using a query grid.

Drag tables you want to use in your query into this area. This diagram shows table fields and relationships (the links) between tables.

To determine the FIELDS, that that should take a part in the query, just select them in the tables.

To determine the KIND OF JOIN - right-click the appropriate link and select the kind in the menu:

Join Kind	Diagram Pict	Description
Inner		The INNER JOIN keyword returns rows when there is at least one match in both tables.
Outer Left		The LEFT JOIN keyword returns all rows from the left table (table_name1), even if there are no matches in the right table (table_name2).
Outer Right		The RIGHT JOIN keyword returns all the rows from the right table (table_name2), even if there are no matches in the left table (table_name1).
Outer Full		he FULL JOIN keyword return rows when there is a match in one of the tables.

The tables list shows all available tables in the database.

This list contains tables related to the currently selected table with their relation kinds.

To design a query, you can use the following tabs:

On this tab you can tune the join options.

• Column – The name of the column.
• Alias – The alias for the column.
• Table – The table to which the field belongs
• Sort Type – The sorting rule for this field.
• Sort Order – The priority of sorting by this field in the result query.
• Function – The function, that will be applied to the field value.
• Filter – The condition for this field.
• Additional Filter – The additional condition.

On the Query Tab, find the SQL statement generated from Query Builder.

On the Result Tab, you can see the actual result of the SQL query.

• SQL Editor. Transfer the results of the Query Editor or Builder to the Valentina Studio SQL Editor