Different types of join include inner, outer, left, right, cross, and self join.

• Inner join returns only the matching rows from both tables.

• Outer join returns all rows from both tables and null values ...read more