Joining Multiple Tables

Joins chain: each JOIN adds one more table, linked by its key to a table already in the query. A many-to-many link goes through its associative table, and a table can even join to itself.

Updated

Cheat sheet: Joining Multiple Tables
Category
SQL
Level
Journeyman
Tags
INNER JOIN, Self Join, sql, t-sql