# 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.

![Cheat sheet: Joining Tables in T-SQL: an overview](https://fsdtrainingmedia.blob.core.windows.net/public/images/2026/11/41c7e8e235ea44f583ad899f961c8bac.webp)

- Category: SQL
- Level: Apprentice
- Tags: join, sql, t-sql
- Updated: November 3, 2026

Source: https://www.ask-codey.com/cheat-sheets/joining-tables-in-t-sql-an-overview-cheat-sheet