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.

Related Sections

• 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.