Virtuoso SQL Builder (Wizard)

Select tables list:

Enter filter for tables:   Selected tables:

Virtuoso SQL Builder (Wizard)

Select columns list:

Select Table: Select Column:   Selected Column (in output order):




Virtuoso SQL Builder (Wizard)

Select table joins rules:

Enter join rule for tables:   List of join rules:
Left table:
Right table:
Left table column:
Right table column:
Association only those records in which the connected fields of both tables coincide
Association of all records from the left table and only those records from right in which the connected fields of both tables coincide
Association of all records from the right table and only those records from left in which the connected fields of both tables coincide


Resulted FROM expression:

Virtuoso SQL Builder (Wizard)

Here you can customize your sql expression by adding filters ('where' clause) and additional calculated fields:

Use following for SQL customization: Resulting SQL expression (you can change it manually or by using left screen side tools).
Table:
Column:
Functions:
Procedures: