CROSS JOIN in SQL Server

Hi,

Cross join is an Cartesian Product its Matrix Format Like 3 * 3 ,5 * 5 format.

create table table_one (col_one number, col_two varchar2(10));
create table table_two (col_three number, col_four varchar2(10));
insert into table_one values ( 1, 'one');
insert into table_one values ( 2, 'two');
insert into table_two values (10, 'ten');
insert into table_two values (20, 'twenty');
insert into table_two values ( 5, 'five');
select * from
table_one cross join
table_two;
Each row from table_one is returned together with each row from table_two:

Regards

Sriram.R

sriram

Sqldev, 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

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

Please refer this links

http://msdn.microsoft.com/en-us/library/ms190690(v=sql.105).aspx
http://en.wikipedia.org/wiki/Join_(SQL)

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

msdn.microsoft.com/en-us/library/ms190690(v=sql.105).aspx

Regards
Muralidoss M

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

CROSS JOIN:
This 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.

example:
select * from table1,table2
or
select * from table1 cross join table2

http://blog.sqlauthority.com/2009/04/13/sql-server-introduction-to-joins-basic-of-joins/

Regards,
Mohamed Shafee M

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

Hii..
check this url
http://www.java2s.com/Tutorial/SQLServer/0080__Table-Join/SQL92CrossJoinSyntax.htm

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

Mark As Answer, if post helps u.

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