Virtuoso SQL Builder (Wizard)
Select tables list:
Enter filter for tables:
Selected tables:
One
One
Virtuoso SQL Builder (Wizard)
Select columns list:
Select Table:
Select Column:
Selected Column (in output order):
One
One
One
Virtuoso SQL Builder (Wizard)
Select table joins rules:
Enter join rule for tables:
List of join rules:
Left table:
One
Right table:
One
Left table column:
One
Right table column:
One
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
One
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:
One
Column:
One
Functions:
One
One
Procedures:
One