What the use of cross join .when we use it

Posted by Sekar.C under Sql Server on 5/24/2012 | Points: 10 | Views : 1996 | Status : [Member] | Replies : 5
Hi,
What the use of cross join .when we use it

Regards
Sekar.c



Responses

Posted by: Pavan_Kumar on: 5/24/2012 [Member] Starter | Points: 25

Up
0
Down

Hi Sekar,
Please go through the below link.
http://weblogs.sqlteam.com/jeffs/archive/2005/09/12/7755.aspx

I hope it helps.

With best rgds,
Pavan

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

Posted by: Sriramnandha on: 5/25/2012 [Member] Starter | Points: 25

Up
0
Down
HI SEKAR,

CROSS JOIN IS AN CARTESION PRODUCT ,ITS MATRIX FORMAT (EX : 3 * 3 ,4 * 4)

SAME RECORDS TO DISPLAY MULTIPLE TIMES TO APPLY CROSS JOIN..

SELECT * FROM TABLE1 CROSS JOIN TABLE

CROSS JOIN CANNOT USE WHERE CONDITION...

REGARDS

sriram

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

Posted by: Muhsinathk on: 6/15/2012 [Member] Bronze | Points: 25

Up
0
Down
Cross join is a Cartesian join that does not necessitate any condition to join. The resultset contains records that are multiplication of record number from both the tables.

SELECT * FROM Employee CROSS JOIN Department

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

Posted by: Muhsinathk on: 6/15/2012 [Member] Bronze | Points: 25
Posted by: Muhsinathk on: 6/15/2012 [Member] Bronze | Points: 25

Up
0
Down
Please refer this link to..

http://msdn.microsoft.com/en-us/library/ms190690%28v=sql.105%29.aspx

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

Login to post response