CROSS JOIN / CARTESIAN JOIN

Modified on Tue, 06 Oct 2020 at 08: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 atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article