what is the difference between full join and cross join?
A cross join produces a cartesian product between the two tables, returning all possible combinations of all rows. ... A full outer join is a combination of a left outer and right outer join.