How SQL JOIN Fan-Outs Silently Inflate Your Totals and How to Fix Them

A common but hard-to-spot SQL mistake occurs when joining multiple tables causes row duplication, inflating SUM() and COUNT() results without triggering any error. This happens because a JOIN produces every matching row combination, so an order joined to four line items appears four times in the result, causing its amount to be counted four times. The phenomenon, known as a 'fan-out,' is especially deceptive because the query is syntactically valid and executes without warnings. Developers can detect the issue by running the JOIN without aggregates first and manually verifying row counts against known data. The recommended fix is to pre-aggregate the one-to-many table in a subquery before joining, ensuring each entity appears only once in the final result set.