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.

Updated

Cheat sheet: INNER JOIN
Category
SQL
Level
Journeyman
Tags
Alias (sql), INNER JOIN, Join Condition, sql, t-sql