How Do I...
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:
- 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.
- Type a description for the query in the Description entry
field. (The description is optional.)
- 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:
Fields
- Query name
- Description
- Tables/views
- Columns
- Column sequence
- Computed columns
- DISTINCT
- SELECT *
Menu-bar choices
- 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.
[ Top of Page | Previous Page | Next Page | Table of Contents ]