Select result columns for a SELECT statement (SELECT clause)

You must select tables for a SELECT statement before you can select result columns.

If you do not select individual result columns for the SELECT statement, all columns are returned by default.

These steps are part of the larger task of creating SELECT statements. When you complete the steps for selecting result columns (SELECT), return to Create a SELECT statement.

To select result columns for a SELECT statement:

  1. In the Outline view, click the SELECT (Result columns) node. A list of columns from the tables that you selected in the FROM (Source tables) node is displayed in the Details area.
  2. Click on a table node in the Available columns list to see the columns in that table.
  3. Select columns from the Available columns list.
  4. Click > to move selected columns to the Selected columns list.
  5. Optional: Click the >> button to add all columns in the Available columns list to the Result columns list.
  6. Optional: Click the << button to remove all columns in the Result columns list.
  7. Optional: Select the Remove duplicate rows (SELECT DISTINCT) check box to exclude duplicate rows from the result set.
  8. Optional: Type a new column name in the Name field next to a selected column, then press Enter to add the new name to the SQL code in the SQL code view.
  9. Optional: Click next to a selected column to open a window where you can create an expression.

Return to Create a SELECT statement.