Columns
The columns for each table that is included in the query
are listed in each table's diagram. In addition, all of
the columns from all of the tables are listed in the bottom section
of the diagram window. The name of the column is specified in Field and
the table the column belongs to is specified in Table.
Unless otherwise specified, all the columns listed in the bottom
section of the diagram interface will be included in the query results.
You can specify whether a column is included in the query results
in one of two ways:
- Using the Include check box in the bottom section of
the window. If this check box is checked, the column is included
in the query results. If unchecked, the column is not included in
the query results.
- From the top section of the window, right-click on a column
name in the table diagram. A context menu opens. Select Remove column to
exclude the column from the query results. The column is removed
from the display in the bottom section of the window. It remains
in the table diagram. Select Add column to include the
column back in the query results. The column is added back to the
display in the bottom section of the window. A column name is
never removed from the table diagram in the top section of the window.
The table diagrams always shows you what columns are available in
the table, the bottom displays shows you want columns will be included in
the query results.
