What the use of cross join .when we use it

Posted by Sekar.C under Sql Server on 5/24/2012 | Points: 10 | Views : 2984 | Status : [Member] | Replies : 5

Hi,
What the use of cross join .when we use it

Regards
Sekar.c

Reply | Reply with Attachment

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

0	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

0	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

0	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

0	http://blog.sqlauthority.com/2009/04/13/sql-server-introduction-to-joins-basic-of-joins/ Sekar.C, if this helps please login to Mark As Answer. \| Alert Moderator

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

0	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

Latest Posts