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.