You enter an SQL statement graphically in the visual query editor.
Note
You can also enter SQL statements in text form.
More information: Entering and Executing SQL Statements
Select Tables in the Explorer.
Choose
in the context menu of Tables.The visual query editor is opened. More information: Visual Query Editor
Use drag and drop to copy the desired tables from the Explorer to the visual query editor.
The system displays secondary key relationships between tables as connecting lines (joins).
Use drag and drop to copy the columns that you want to display in the result view to the Query Columns area.
(Optional:) In the Query Columns area, enter search conditions and other attributes of the result view.
Property |
Description |
---|---|
Synonym |
Synonym for the column name in the result view |
Visible |
Column is displayed in the result view. |
Order |
Listing of column values in the result view |
Predicate |
Search condition
More information: SQL Reference Manual, |
To display the SQL statement in text form, choose Export SQL in the context menu of the visual query editor.
To execute the SQL statement, choose Execute SQL in the context menu of the visual query editor.
To link one table column with another table column using a join, drag the column of the first table and drop it onto the column of the second table.
The join is displayed as a connecting line between both table columns.
To edit the join properties, choose Join Properties in the context menu of the connecting line and enter the join properties.
To delete a join, choose Delete in the context menu of the connecting line.
If you copy the same table to the table selection twice, the system assigns an alias name. You can create SELF JOINS in this way.
More information: SQL Reference Manual,