Select this option to begin building the SQL select statement.

Pressing OK in the Select dialog box adds the SELECT clause to the select statement.  The SQL Statement window displays the SELECT clause.

Select Dialog Box

Table:

The tables in the database are displayed.  Select a table that you want to use in your statement.  Once you have completed your selections for one table, select another table if you want to create a multi-table SELECT statement.

If you do select more than one table, you will be asked when you press OK whether you wish to have a Join clause generated automatically for the SELECT statement.

If you want to create a Join clause, ESL SQL Wizard will display the Join dialog box with selections completed for you, provided there are matching primary key columns in the tables.

You may add a Join clause at any point from the Join option in the SQL Statement menu.

Columns:

The columns in the table selected are displayed.  An asterisk preceding a column denotes a primary key column.  Select the column(s) from the table that you want to use in your statement.

Selected:

Move the columns that you have highlighted into the Selected list box.  The Selected list box is the source for the columns that will be part of the SELECT statement.

>

Use the > push button to move one or more highlighted columns from the Columns list box into the Selected list box.

>>

Use the >> push button to move all columns into the Selected list box.

<

Use the < push button to remove a highlighted column or columns from the Selected list box.  

<<

Use the << push button to remove all the columns from the Selected list box.  

Move

Use the Move push button to rearrange the columns in the Selected list box.  Highlight the column you want to move.  Click the Move push button. Then highlight the item below the new position for the column.  If no column is highlighted, the column is moved to the end of the list.

Distinct Rows Only:

Check this box if you want to eliminate duplicate rows from the result set when you run this SELECT statement.  This inserts the keyword DISTINCT into the SELECT statement.

Column Expressions:

The Columns Expression dialog box is where you can specify column functions.  The functions available depend on the column's type. For example, AVG, MIN, MAX, COUNT, and SUM column functions are available for "numbered" columns.  When you select a column, you have the option of specifying that column in a column function within the Column Expressions dialog box.