Columns tab

Available Columns This box lists all the tables you chose for your query, and the columns in each table.
Selected Columns By default, all columns are selected for your query. To delete a column, select it in the Selected Columns box and click the Left Arrow. To display a column in your result set, select a column or set of columns in the Available Columns box and click the Right Arrow. Use the Up and Down Arrows to reorder the columns in the Selected Columns box.
If you select the same column more than once, an alias is applied. You can edit the alias name.
DISTINCT Select DISTINCT to eliminate duplicate rows from your result set.

Note

Many statements take significantly longer to execute when DISTINCT is specified, so you should reserve DISTINCT for cases where it is necessary. In addition, DISTINCT treats nulls as duplicates, so when you select DISTINCT, only one NULL value is returned in the results.
Limit Rows Retrieved To The If you select Limit Rows Retrieved To The you have the option of choosing either FIRST Row to retrieve only the first row of the result set, or TOP, which allows you to specify the number of rows that you want retrieved. No matter what you choose, the maximum number of rows that appear in the Query Editor is 25.
Results Click Results at the bottom of the window to see the results of your query, or an error message if the query contains errors.
SQL Click SQL at the bottom of the window to see the SQL statements for your query.

To add a subquery in the Query Editor, click the Add A Computed Column button, which is located between the Available Columns box and the Selected Columns box. The Expression Editor appears. In the Expression Editor, click the Edit A Subquery And Insert The Results Into The Editor button, which is located beside the Not button.

Columns tab

Components

Note

Adding a subquery

See also