An INNER JOIN returns only the rows that have matching values in both tables, while a LEFT JOIN returns all the rows from the left table and the matched rows from the right table. You would use INNER JOIN when you only want records that exist in both tables, and LEFT JOIN when you want all records from the left table regardless of matches in the right table.