What is the difference between INNER JOIN and LEFT JOIN in SQL?
INNER JOIN returns only rows that have a match in both tables, while LEFT JOIN returns every row from the left table and fills the right table's columns with NULL when there is no match.