Explain the difference between a left join and an inner join, and provide a real-world scenario where using the wrong one would corrupt your analysis.