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. The selected columns are moved from the Columns to include list to the Columns list.
To change the order of columns in the Columns to include list, select the columns whose position you would like to change and then select Move up or Move down.
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.
Specifying the tables for an SQL statement
Joining tables
Specifying search conditions
Sorting the result set
Remapping data to a different SQL data type
Displaying the SQL statement