Specifying Result Columns

Use the Columns page of the SQLAssist SmartGuide to specify the columns in the result set. The column names will appear in the SELECT clause of the SQL statement.


Columns page of SQL Assist SmartGuide

  1. Select a table from the Selected table(s) drop-down list. The list includes only the tables that are selected in the Tables page.

  2. Select one or more columns from the Columns list. The list includes the columns for the selected table. Use Select all to select all the columns in the list. Use Deselect all to deselect all selected columns in the list.

  3. Select Add to add the selected columns to the Columns to include list. The selected columns are removed from the Columns list.

    To remove one or more columns from the Columns to include list, select the columns and select Remove. You can navigate through the list by selecting Move down or Move up. The selected columns are added to the Columns list.

When you finish specifying the result columns, select Next. This displays the Sort page of the SQLAssist SmartGuide. Use that page to sort the result set.

Select Back to display the Condition page of the SQLAssist SmartGuide. If appropriate, you can then change the search conditions for the SQL statement.

You can also display any page in the SQL Assist SmartGuide by selecting its tab.

When you complete the specification of your SQL statement, select Finish. This generates the code for the SQL statement and closes the SQLAssist SmartGuide.

To cancel the visual composition of the SQL statement, select Cancel.