Selecting fields in the SQL designer
In the SQL designer, each table window in the table pane has a table and field name with a check box that allows you to select some or all fields to be included in the result set.
Selecting all fields in a table
In a table window, click on the table name’s check box to add a blue check mark. A blue check mark indicates that all fields are selected. Uncheck this box to remove all fields from the query. If the check box has a gray check mark, only a portion of the fields have been selected to appear in the result set.
The F6 key and spacebar also enable you to toggle field selections.
Selecting all fields automatically adds them to the Selection page.
Selecting individual fields in a table
Check each field you wish to appear in the result set. When a field is checked and unchecked, it is automatically added to and removed from the Selection page.
Fields can also be selected by dragging them from the table window and dropping them on the Selection page grid.
Reordering selected fields
In the left gray column of the grid, drag the row and drop it at the new location.