Full outer join will fetch at maximum 'addition of 2 tables'
Ex: Table A - 2 rows; Table B - 3 rows.
Full outer join will fetch in 2+3 = 5 rows.
Where as in Cartesian product will fetch in 'product of 2
tables'.
Ex: Table A - 2 rows; Table B - 3 rows.
Full outer join will fetch in 2x3 = 6 rows