Difference between cross join and Full outer join

By j Miracle

The difference between cross join and full outer join.

the difrence between the cross join full outer join are as follow.

Cross Join :
No join conditions are specified.
Results in pairs of rows.
Results in Cartesian product of two tables.

Full Outer Join:
A combination of both left and right outer joins.
Results in every row from both of the tables , at least once.
Assigns NULL for unmatched fields.

Difference between cross join and Full outer join  (841 Views)