Querying 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
How to: 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.How to: Join Tables Automatically (Visual Database Tools)
Steps for allowing the Query and View Designer determine if tables should be joined.How to: Join Tables Manually (Visual Database Tools)
Steps for creating a join manually in the Diagram pane.How to: Join Tables on Multiple Columns (Visual Database Tools)
Steps for joining tables with multiple criteria for each table.How to: Create Outer Joins (Visual Database Tools)
Specify that joined tables should include rows even when they do not match rows in the corresponding table.How to: Remove Joins (Visual Database Tools)
Steps for removing a join between tables.How to: Create Self-Joins Automatically (Visual Database Tools)
Steps for allowing the Query and View Designer to create a self-join.How to: Create Self-Joins Manually (Visual Database Tools)
Steps for using a join to find subsets of data within a single table.How to: 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.Performing Basic Operations with Queries (Visual Database Tools)
Provides links to topics covering the most common query tasks.Specifying Search Criteria (Visual Database Tools)
Provides links to topics covering the various kinds of search criteria and how to use them.