Introduction to Joins

Joins are used to combine rows from two or more tables based on a related column between them. Joins are essential for normalized database designs.

Types of joins:

  • INNER JOIN
  • OUTER JOIN (LEFT, RIGHT, FULL)
  • SELF JOIN
  • CROSS JOIN