Switch to: V12V11V10V9V8V7V6V5

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.

Query Editor Overview

Work Area

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 Kinds

Join Kind Diagram Pict Description
Inner Inner Join Pict The INNER JOIN keyword returns rows when there is at least one match in both tables.
Outer Left Outer Left Join Pict 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 RightOuter Right Join PictThe 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 Outer Full Join Pict he FULL JOIN keyword return rows when there is a match in one of the tables.

Tables List

The tables list shows all available tables in the database.

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

Editor Panel

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

Select Tab

On this tab you can tune the join options.

 Query Editor - Select Tab

  • 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.

Query Tab

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

Query - Query Tab

Result Tab

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

Query Editor Result Tab

See Also

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