INNER JOIN versus LEFT JOIN Ask what must survive unmatched. The blanks from the LEFT JOIN make the report messy. Response Those blanks are the unmatched cases; removing them changes the metric population. Filtering NULLs after a LEFT JOIN can erase the denominator. It connects NULL output to business meaning. What does CROSS JOIN create? Every combination of rows from both inputs. Useful for planning grids; dangerous by accident. What is the first check after a surprising join? Count rows before and after each join at the intended grain. The jump points to the multiplying relationship.
Read the full lesson
Sign up free: one personalized lesson every day, matched to your role and goals.
Already have an account? Sign in