Select Columns Dialog Box
The Select Columns dialog box displays the following items:
Available Columns
Displays columns, defined to the selected tables, that are available to query, add to, or update. Each column name is qualified by its table name. Double-click a listed column or select it and then click the Add button to add it to the list of selected columns.
Add/Remove/All Buttons
|
Button |
Description |
|
Add -> |
Adds the item selected in the Available list to the Selected list. |
|
All ->> |
Adds all the items in the Available list to the Selected list. |
|
<- Remove |
Moves a selected item from the Selected list to the Available list. |
|
<<- All |
Moves all items in the Selected list to the Available list. |
Selected Columns
Displays columns selected to include in the SQL statement.
Up/Down Arrow Buttons
|
Button |
Description |
|
Up Arrow |
Click this button to move the selected item higher in the Selected list. |
|
Down Arrow |
Click this button to move the selected item lower in the Selected list. |
Return Unique Rows
When selected, returns only one occurrence of rows with duplicate values; when clear, returns rows with duplicate values.
