CROSS JOIN In SQL?

Forums SQLCROSS JOIN In SQL?
Staff asked 3 years ago

In which scenario we can use CROSS Join?

can anyone explain with an example?

Answers (1)

Add Answer
Staff answered 3 years ago

Hello, @Shaikh Hafeezjaha

We can use CROSS join when we want the combination of each row of the first table with every row of the second table. We can also call it cartesian join. 

Subscribe

Select Categories