where to use cross join ?and example?

Posted by Chamu under Sql Server on 12/27/2017 | Points: 10 | Views : 1036 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

where to use cross join ?and real example? and when ?

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

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

Latest Posts

Climax Delay Condoms for Long Lasting Pleasure (0)
Iterating over columns of dataframe and print as rows in Python Django (0)
Where can I found sample MVC projects to learn and improve skills (1)
Extract a value from HTML string (0)
Get only year part from date string in SQL server (0)
Get only year part from date string in SQL server (0)
Get only year part from date string in SQL server (0)
Get only year part from date string in SQL server (0)
More ...