Joining Tables in T-SQL: an overview

A join puts related rows from two tables side by side, matched on their key columns. An inner join keeps only matches; an outer join also keeps the rows with no match.

Updated

Cheat sheet: Joining Tables in T-SQL: an overview
Category
SQL
Level
Apprentice
Tags
join, sql, t-sql