This page of the property sheet “Properties of query” serves for editing of SQL statement SELECT which determines the query.
Drop-down lists | Owner – a drop-down list of owners of components of external data source (if the source supports the notion of an owner); Table – a drop-down list of names of all tables of the present EDB. If the owner's name is specified, only the tables based on the data components which belong to this owner are displayed; Field – a drop-down list of names of all fields of selected table. |
Editing pane of SELECT statement | Intended for entering text specifying SELECT statement. To use names from lists in the text of SELECT statement it is necessary to place the input caret to the required place of the text which is being entered, select the name in the list of owners, tables or fields and then push one of the buttons When pushing the button When pushing the button |
Building EDB query using SELECT statement
Properties of query on the basis of SELECT statement