This post serves as a series of links to the different kinds of multi-table queries. The Microsoft Press book called T-SQL Querying by Itzik Ben-Gan et al organizes the different types of multi-table queries into five sections as shown below.

Subqueries

• Self-contained subqueries
• Correlated subqueries

Table Expressions

• Derived Tables
• Common Table Expressions (CTE)
• Views
• Inline Table-Valued Functions (TVFs)

The APPLY operator

Joins

• Cross Joins
• Inner Join

-228

• Outer Join
• Self-Join
• Equi and Nonequi Joins
• Multi-join

Union, Except and Intersect

• Union
• Except
• Intersect

Other Related Posts at BeginCodingNow.com

There are several posts that we have at this site that discuss mult-table queries and do not use Itzik’s database. Below is a list of some of them.

SQL Joins Introduction
SQL Joins using Geographic Data
SQL Many-to-Many Relationships