Why Your JOIN Doubled Your Totals — There's No Error, Just the Wrong Number

SQL doesn't warn you when a JOIN multiplies your rows — it just quietly hands back more of them than you expected, and every SUM() and COUNT() downstream inherits the mistake. Here's the exact mechanism, and how to catch it before it ships.