# INNER JOIN

INNER JOIN combines two tables on a matching column, keeping only rows that match. Table aliases keep it short, and the joined columns can be filtered, grouped and sorted like any others.

![Cheat sheet: INNER JOIN](https://fsdtrainingmedia.blob.core.windows.net/public/images/2026/11/1d35b9eb74b746b3abf82231c85cb870.webp)

- Category: SQL
- Level: Journeyman
- Tags: Alias (sql), INNER JOIN, Join Condition, sql, t-sql
- Updated: November 3, 2026

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