Inner join returns only the matching rows between two tables, while left join returns all rows from the left table and the matching rows from the right table.

• Inner join result: 1 2 3

• Left join result: ...read more