Inner join returns only matching rows, left join returns all rows from left table and matching rows from right table, outer join returns all rows from both tables

• Inner join: Returns rows that have mat...read more