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.
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.