The diagram view of a query
You can build simple to complex queries visually using
the diagram query interface. Select New --> Query,
then View --> Diagram to start building
a query using the diagram query interface.
There are two main sections in the diagram query window:
- The top section which displays the tables that are included
in the query as diagrams
- The bottom section which lists the columns from the tables that
will be included in the query results
In creating a query using the diagram interface you can specify
one or more of the following elements:
- You must specify the Tables that will be used in the
query.
- If you are using more than one table, you must specify the Join Conditions that
will link the tables.
- You can specify what Columns will be included in the
query results. By default, all columns in all the tables are included
in the query results.
- You can apply Sort Conditions control how the rows
in the query results will be sorted.
- You can specify Row Conditions that will limit the
rows that are returned in the query results.
