CROSS JOIN / CARTESIAN JOIN

Modified on Tue, 6 Oct, 2020 at 8:58 PM

A CROSS JOIN is a Cartesian product of Table A and Table B. Every row from Table A is matched with every row from Table B.

As per the below example, every customer from Table A will be associated with all the products from Table B. This will have 3*3 = 9 records in the result.




Join joins cross join cartesian join

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article