SQL

The query language itself, across engines.

Official documentation

SQL INNER JOIN vs LEFT JOIN: which rows each one returnsINNER JOIN returns only rows that match on both sides; LEFT JOIN keeps every left row and fills NULL where nothing matches. Shown with real query output.