Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
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
| Article | Description |
|---|---|
| Modify join operators | Specify that tables should be joined using an operator other than equal (=). |
| How the Query and View Designer represents joins | Explains the graphic representation of the join as you see it in the Diagram pane. |
| Join tables automatically | Steps for allowing the Query and View Designer determine if tables should be joined. |
| Join tables manually | Steps for creating a join manually in the Diagram pane. |
| Join tables on multiple columns | Steps for joining tables with multiple criteria for each table. |
| Create outer joins | Specify that joined tables should include rows even when they don't match rows in the corresponding table. |
| Remove joins | Steps for removing a join between tables. |
| Create self-joins automatically | Steps for allowing the Query and View Designer to create a self-join. |
| Create self-joins manually | Steps for using a join to find subsets of data within a single table. |
| View join properties | Steps for viewing the properties of a join. |