An INNER JOIN returns only the rows where there is a match between the two tables being joined, while a LEFT JOIN returns all rows from the left table and the matched rows from the right table. You would use an INNER JOIN when you only want records that have corresponding entries in both tables, and a LEFT JOIN when you want all records from the left table regardless of matches in the right table.