Types of joins include inner join, outer join (left, right, full), cross join, self join.

• Inner join: returns rows when there is a match in both tables

• Outer join: returns all rows from one table and ma...read more