---
title: "What is Cross Join?"  
description: "What is Cross Join?"  
author: "Sumit Kesarwani"  
published: 2013-12-22  
updated: 2020-09-11  
canonical: https://www.mindstick.com/interview/1850/what-is-cross-join  
category: "c#"  
tags: ["c#"]  
reading_time: 1 minute  

---

# What is Cross Join?

A cross join that does not have a WHERE clause produces the Cartesian product of the tables involved in the join. The size of a Cartesian product result set is the number of rows in the first table multiplied by the number of rows in the second table.

## Answers

### Answer by Sumit Kesarwani

A cross join that does not have a WHERE clause produces the Cartesian product of the tables involved in the join. The size of a Cartesian product result set is the number of rows in the first table multiplied by the number of rows in the second table.


---

Original Source: https://www.mindstick.com/interview/1850/what-is-cross-join

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.