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