Inner join returns only matching rows from both tables while left join returns all rows from left table and matching rows from right table.

• Inner join is used to retrieve data that exists in both table...read more