SQL X vs Y

The query language itself, across engines.All SQL pages

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.