A query result can include data from multiple tables or table-structured objects. To combine data from multiple table-structured objects, you use the JOIN operation from SQL. For more information, see Combining Tables.
For information about creating queries using multiple tables, see the following topics:
| To | See |
|---|---|
| Learn the different ways in which tables can be joined | Types of Joins |
| Learn how the Query Designer displays join information in the Diagram pane | How the Query Designer Represents Joins |
| Let the Query Designer determine if tables should be joined | Joining Tables Automatically |
| Join tables yourself | Joining Tables Manually |
| Specify that tables should be joined using an operator other than equal (=) | Modifying Join Operators |
| Specify that joined tables should include rows even when they do not match rows in the corresponding table | Creating Outer Joins |
| Use a join to find subsets of data within a single table | Creating Self-Joins |
| Remove a join between tables | Removing Joins |