Querying with Joins

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

• Tables in Joins
  Explains various ways to join tables and how to choose what option is best.

• Columns in Joins
  Explains how to use related and unrelated columns in a query and when you would use each.

• Join Comparison Operators
  Lists operators (<, +, =, etc.) and explains how to use them.

• How to: Modify Join Operators
  Specify that tables should be joined using an operator other than equal (=).

• Types of Joins
  Lists the types of joins and how to choose with one to use.

• How the Query and View Designer Represents Joins
  Explains the graphic representation of the join as you see it in the Diagram pane.

• How to: Join Tables Automatically
  Steps for allowing the Query and View Designer determine if tables should be joined.

• How to: Join Tables Manually
  Steps for creating a join manually in the Diagram pane.

• How to: Join Tables on Multiple Columns
  Steps for joining tables with multiple criteria for each table.

• How to: Create Outer Joins
  Specify that joined tables should include rows even when they do not match rows in the corresponding table.

• How to: Remove Joins
  Steps for removing a join between tables.

• Using a Table Twice in One Query
  Explains the various ways to join a table to itself.

• How to: Create Self-Joins Automatically
  Steps for allowing the Query and View Designer to create a self-join.

• How to: Create Self-Joins Manually
  Steps for using a join to find subsets of data within a single table.

• How to: View Join Properties
  Steps for opening the properties window for a join.

Related Sections

• Types of Queries
  Provides links to topics describing the supported query types.

• Expressions in Queries
  Provides links to topics about what expressions you can use and how to use them.

• Performing Basic Operations with Queries
  Provides links to topics covering the most common query tasks.

• Specifying Search Criteria
  Provides links to topics covering the various kinds of search criteria and how to use them.