Thursday, February 28, 2013

What is the difference between a full outer join and a cross join?

For sets of A and B rows, a cross join (aka Cartesian join) fetches a result of A * B rows whereas a full outer join pulls a return of at most A + B rows.

No comments :