SELECT Details

Use the SELECT Details window to specify an SQL SELECT statement interactively.

Fields

•	Query name

•	Description

•	Tables/views

•

Columns

•	Column sequence

•	Computed columns

•

DISTINCT

•

SELECT *

Menu-bar choices

•

Clause

Push buttons

•	Select Apply to accept the SELECT statement and close the window.

•	Select Show SQL to display the SELECT statement you have specified.

Tasks

•	Specifying a SELECT statement

Opening SELECT Details

You can get to the SELECT Details window from the following windows:

•	Multi-Row Query - Settings

•	Database Query - Settings

•	Select a query