Removing Columns from Query Output

If you are using a column in a Select query but don’t want to display it in the result set (that is, you don’t want it in the query’s select list), you can remove it from output. After you remove the column from the query’s output, you can still use it in a search condition, to sort the query, and so on.

Note   If you want to remove a column from the query altogether, see Removing Columns from the Query.

To remove a column from the query output

• In the Diagram pane, clear the check box next to the name of the column you want to remove.

  -or-

• In the Grid pane, clear the check box in the Output column for the data column you want to remove. (If you want to add the column back to the query output, you can check the Output column again.)

  -or-

• Remove the column from the output list in the SQL pane.