Explain the difference between a LEFT JOIN and an INNER JOIN, and describe a scenario where using the wrong join would corrupt your business metrics.