Selecting Columns in an SQL SELECT Command

To select columns in an SQL SELECT command using the SQL Wizard:

1. Run the SQL Wizard and on the Select Operation dialog box, click SQL Select.
2. Proceed in the SQL Wizard until you reach the Select Columns dialog box.
3. In the Select Columns dialog box's Available Columns list, select a column and click Add. Repeat this action for each column required in the SQL Statement or, to add all the columns, choose * (All Columns) or click All >>.
4. To re-order the sequence of selected columns, select a column in the Selected Columns list and click the Up or Down arrow to move the column up or down in the list.
5. Click Next to continue creating the query.

- Or -

Click Back to return to the previous screen in the SQL Wizard.

- Or -

Click Finish if the query is done.

NOTE: To remove a column from the statement, select it from the Selected Columns list and click Remove All to remove all the columns in the statement.

See Also