INNER JOIN: Returns only the rows where there is a match in both tables being joined.
LEFT JOIN: Returns all rows from the left table (table1), and the matched rows from the right table (table2). The result will contain all records from the left table, and the matched records from the right table. If there is no match, NULL values will be returned for columns from the right table.