Cross join combines every row of the first table with every row of the second table. Self join joins a table with itself.

• Cross join results in a Cartesian product, while self join is used to join a ta...read more