The dialog box “Join” serves for selecting the EDB table to be joined and join fields.
Query base field | A drop-down list serves for selecting the join field of the root query. |
Table | A list serves for selecting the table to be joined. The list contains tables of the current EDB which do not participate in the present query. For every table, apart of its name, the owner and type of the corresponding component of external data source is specified (the following types are possible: table, view, system table or synonym). |
Field | A drop-down list serves for selecting the joining field of EDB table to be joined. This list contains only the fields which type corresponds to the type of the base field of the query. |
OK | The button serves for confirming creation of the join. |
Cancel | Cancels actions performed in the dialog box and closes the dialog box. |
“Properties of query” for EDB. Page “Joins”
Command Join for a field in table browser window