Query with Joins (Visual Database Tools)

A query result can include data from multiple tables or table-valued objects. To combine data from multiple table-valued objects, you use the JOIN operation from SQL.

For information about creating queries using multiple tables, see the following topics.

In This Section

Modify Join Operators (Visual Database Tools)
Specify that tables should be joined using an operator other than equal (=).

How the Query and View Designer Represents Joins (Visual Database Tools)
Explains the graphic representation of the join as you see it in the Diagram pane.

Join Tables Automatically (Visual Database Tools)
Steps for allowing the Query and View Designer determine if tables should be joined.

Join Tables Manually (Visual Database Tools)
Steps for creating a join manually in the Diagram pane.

Join Tables on Multiple Columns (Visual Database Tools)
Steps for joining tables with multiple criteria for each table.

Create Outer Joins (Visual Database Tools)
Specify that joined tables should include rows even when they do not match rows in the corresponding table.

Remove Joins (Visual Database Tools)
Steps for removing a join between tables.

Create Self-Joins Automatically (Visual Database Tools)
Steps for allowing the Query and View Designer to create a self-join.

Create Self-Joins Manually (Visual Database Tools)
Steps for using a join to find subsets of data within a single table.

View Join Properties (Visual Database Tools)
Steps for viewing the properties of a join.

Types of Queries (Visual Database Tools)
Provides links to topics describing the supported query types.

Perform Basic Operations with Queries (Visual Database Tools)
Provides links to topics covering the most common query tasks.

Specify Search Criteria (Visual Database Tools)
Provides links to topics covering the various kinds of search criteria and how to use them.