where to use cross join ?and example?

Posted by Chamu under Sql Server on 12/27/2017 | Points: 10 | Views : 93 | Status : [Member] | Replies : 1
where to use cross join ?and real example? and when ?


Posted by: Giselle on: 12/27/2017 [Member] Starter | Points: 25

The SQL CROSS JOIN produces a result set which is the number of rows in the first table multiplied by the number of rows in the second table if no WHERE clause is used along with CROSS JOIN.This kind of result is called as Cartesian Product. If WHERE clause is used with CROSS JOIN, it functions like an INNER JOIN. http://www.traininginmarathahalli.in/hadoop-training-in-bangalore

Chamu, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response