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