Difference between cross join and Full outer join?

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.

Tagged . Bookmark the permalink.

Leave a Reply