Use the SELECT Details window
To interactively create SQL syntax for a SELECT statement, select Create in the Multi-row Query Settings window. The SELECT Details window is displayed, with the tables and views of the database defined in the connection specification listed in the Tables/views list.
To define a SELECT statement:
1. Type a name for the query in the Query name entry field. The name must be unique within a particular access set, and it cannot contain double-byte characters or spaces.
2. Type a description for the query in the Description entry field. (The description is optional.)
3. Use the list panes and menus on the SELECT Details window to define the tables, columns, and clauses to be included in the query. For instructions on using this window, select the following items:
a. Fields
1. Query name
2. Description
3. Tables/views
4. Columns
5. Column sequence
6. Computed columns
7. DISTINCT
8. SELECT *
b. Menu-bar choices
1. Clause
4. To save your query, select Apply.
Your query is saved in the access set and you are returned to the Multi-row Query Settings window. The name and description of your query are displayed in the Query name drop-down list and Description field, respectively.
Last modified date: 08/13/2019