Just to be clear, there are 5 types of a SQL joins: Cross-join or Cartesian Product - Joins all rows from one relation with rows from the other relation Inner join - Joins only those rows that have same data in the common attributes of the two relations Read More...