In relational databases, this type of join simply combines the rows of one table with the rows of another table, without trying to match the rows from both tables through common column values or keys. If one table has m rows while the other has n rows, then the resulting table of this join would have mn rows.

Outer join

Self join

Inner join

Cross join