Removing Columns from the Query
If you no longer want to use a column in a query, you can remove it. If you do, the Query Designer removes references to the column in the select list, the sort specification, the search criteria, SQL pane, and any grouping specifications.
To remove a column from the query
- In the Grid pane, select the grid row containing the column you want to remove and then press DELETE.
- Remove all references to the column in the SQL pane.