From Dev.to
How a LEFT JOIN Lost a $1,000 Invoice at Month-End
An invoice for $1,000 is open on September 30. On October 1 the customer pays $400. Run the September report again and the invoice disappears. A customer who paid nothing still shows up just fine. You...