What is the purpose of SQL Select?
This is a multi-purpose query tool that lets you perform any of the following tasks:
- Filter your data, so that you see only the rows and columns that interest you.
- Perform relational joins combining two or more tables into one results table.
- Create derived columns (columns that calculate new values based on the contents of your existing columns).
- Sort your data by numeric and/or alphabetic criteria.
- Subtotal your data, so that you see only a listing of subtotals instead of seeing your entire table.
When is SQL Select active?
When at least one table is open.
How Do I Access SQL Select?
On the TABLE, MAP, or SPATIAL tab, in the Selection group, click SQL Select.
See Also: