Cross join, or Cartesian join, combines every row from one table with every row from another table, resulting in a table with all possible combinations. It is used when there is no common column between the tables. The resulting table has a row count equal to the product of the row counts of the joined tables.