New Statement button

Use to create a new SQL statement for the current SAM. Equivalent to selecting SQL Statement>New.

Statement drop-down list

Lists the names of the SQL statements in the current SAM. Use to open a statement. Equivalent to selecting SQL Statement>Open, and then selecting a name from the Statement name list box.

Statement Type field

Located to the right of the Statement drop-down list. Displays the type of the current SQL statement.

Tables button

Use to select tables and columns from the current database to include in the current statement. Equivalent to selecting SQL Statement>Tables.

Where button

Use to specify the search conditions for the current statement. Equivalent to selecting SQL Statement>Where.

Join button

Use to create a join clause between two selected tables. Equivalent to selecting SQL Statement>Join.

Group by button

Use to divide a result set into groups of rows. Equivalent to selecting SQL Statement>Group by.

Order by button

Use to sort the rows of your result set. Equivalent to selecting SQL Statement>Order by.

Run button

Use to dynamically execute the current SQL statement (except for positioned UPDATEs and positioned DELETEs), and to commit or rollback the database changes. Equivalent to selecting SQL Statement>Run.

Link variables button

Use to link selected output columns or SQL statement input parameters with EASEL variables. Equivalent to selecting SQL Access Module>Link variables.