Understanding When a LEFT JOIN Becomes an INNER Join Due to Silently Converted Filters

How to Avoid Duplicate Rows with Left Outer Join and Group By Clause in SQL Server

Optimizing Book Inventory: Calculating Remaining Copies with SQL Join and Filtering