Difference between cartesian product and full outer join?

1 answer

Answer

1084062

2026-04-26 18:40

+ Follow

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

ReportLike(0ShareFavorite

Copyright © 2026 eLLeNow.com All Rights Reserved.