
Archive:
- November 2026 (6)
- October 2026 (6)
- September 2026 (5)
- August 2026 (8)
- July 2026 (8)
- June 2026 (7)
- May 2026 (7)
Search site:
Tags:
Availability Groups (3) Concurrency (3) debian (4) docker (2) Execution Plans (7) Indexes (4) internals (12) linux (7) MongoDB (2) MR2 (2) Optimization (7) Performance (9) Performance Tuning (3) postgres (8) Powershell (4) RCSI (2) SQL Server (32) Statistics (2) Version Store (2) windows server (3)
Categories:
Docker (2) Linux (5) MongoDB (2) PostgreSQL (8) Powershell (3) SQL (1) SQL Server (33) Windows Server (3)
Category: SQL
-
Left join pitfalls – LEFT JOIN + INNER JOIN = INNER JOIN

This post is a quick public service announcement to serve as a reminder to be careful with joins in SQL, particularly in queries with a large number of INNER and LEFT JOINs. An INNER JOIN onto a LEFT JOIN will effectively make that LEFT JOIN an INNER JOIN. Example The test query below is against…