Discussion Forum | Board Infinity

Structured query language cross join vs full join

what is the difference between cross join and full join in mysql?

A cross join produces a cartesian product between the two tables, returning all possible combinations of all rows. It has no on clause because you’re just joining everything to everything. A full outer join is a combination of a left outer and right outer join

cross join-returning all possible combination with all rows.
full join- combination of left and right outer join

cross join is a cartesian product that does not require any condition to join tables. In simple words, the result set of cross join is the all possible combinations of rows and columns of both the tables.

full join is the basically a combination of a left outer and right outer join.