Switch to: V9V8V7V6V5

SQL Builder Help

Valentina Studio provides a visual SQL Builder tool. 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 SQL Builder can be an excellent tool for learning SQL syntax.

SQL Builder Overview

Working Area

You should drag tables, that should take a part in the query, to this area for future processing. 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 on 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. If you used the table in the query (dragged to the working area), then this table will removed from the list.

Builder Panel

To design query, you can use two three tabs tabs:

Select Tab

On this tab you can tune the join options.

 SQL Builder - 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.

SQL Tab

On this tab you can observe the designed query.

SQL Builder - SQL Tab

  • Execute – Executes the query and shows result in additional tab.
  • Open in SQL Editor – Opens the SQL Editor, with the designed query.

Result Tab

This tab displays the result of a query execution from SQL Builder.

SQL Builder Result Tab