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.
Tags: Join, joins, cross join, cartesian join, Cartesian Product, Table A, Table B, Customer Data, Product Data, Matching Rows, Result Set, Combinations, All Possible Combinations, Multiplicative Result,
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article