Interview question · Technical or skills round
“What's the difference between a LEFT JOIN and an INNER JOIN, and when has it mattered?”
Data Analyst
How to answer it
Explain the difference, then give a real case where the wrong join silently dropped or duplicated rows and how you caught it.
