SQL Query

hi everyone. i'm new to sql server.

i have 2 tables. i want to return \all rows in both tables for each
row in table2. please refer to the following. sorry can't get my
thoughts across clearly.

thanks in advance

create table table1 (
c1 char(1),
c2 tinyint
)

insert into table1 values ( 'A', 1 )
insert into table1 values ( 'B', 2 )
insert into table1 values ( 'C', 3 )

create table table2 (
c1 char(1),
c2 tinyint
)

insert into table2 values ( 'D', 4 )
insert into table2 values ( 'E', 5 )

--return table1.*, table2.* from table1 for each row in table2

/*
table1 tabl1 table2 table2
c1 c2 c1 c2
A 1 D 4
B 2 D 4
C 3 D 4
A 1 E 5
B 2 E 5
C 3 E 5
*/

Re: SQL Query

On Nov 15, 10:14 am, may_sapak1...@yahoo.com wrote:
> hi everyone. i'm new to sql server.
>
> i have 2 tables. i want to return \all rows in both tables for each
> row in table2. please refer to the following. sorry can't get my
> thoughts across clearly.
>
> thanks in advance
>
> create table table1 (
> c1 char(1),
> c2 tinyint
> )
>
> insert into table1 values ( 'A', 1 )
> insert into table1 values ( 'B', 2 )
> insert into table1 values ( 'C', 3 )
>
> create table table2 (
> c1 char(1),
> c2 tinyint
> )
>
> insert into table2 values ( 'D', 4 )
> insert into table2 values ( 'E', 5 )
>
> --return table1.*, table2.* from table1 for each row in table2
>
> /*
> table1 tabl1 table2 table2
> c1 c2 c1 c2
> A 1 D 4
> B 2 D 4
> C 3 D 4
> A 1 E 5
> B 2 E 5
> C 3 E 5
> */

This is a simple example of CROSS JOIN. You can write any of the
following query to get your output.

select * from table1,table2

or

select * from table1 cross join table2

Rgds,
Om

Re: SQL Query

thanks a lot

On 15 Nob, 17:22, Om wrote:
> On Nov 15, 10:14 am, may_sapak1...@yahoo.com wrote:
>
>
>
> > hi everyone. i'm new to sql server.
>
> > i have 2 tables. i want to return \all rows in both tables for each
> > row in table2. please refer to the following. sorry can't get my
> > thoughts across clearly.
>
> > thanks in advance
>
> > create table table1 (
> > c1 char(1),
> > c2 tinyint
> > )
>
> > insert into table1 values ( 'A', 1 )
> > insert into table1 values ( 'B', 2 )
> > insert into table1 values ( 'C', 3 )
>
> > create table table2 (
> > c1 char(1),
> > c2 tinyint
> > )
>
> > insert into table2 values ( 'D', 4 )
> > insert into table2 values ( 'E', 5 )
>
> > --return table1.*, table2.* from table1 for each row in table2
>
> > /*
> > table1 tabl1 table2 table2
> > c1 c2 c1 c2
> > A 1 D 4
> > B 2 D 4
> > C 3 D 4
> > A 1 E 5
> > B 2 E 5
> > C 3 E 5
> > */
>
> This is a simple example of CROSS JOIN. You can write any of the
> following query to get your output.
>
> select * from table1,table2
>
> or
>
> select * from table1 cross join table2
>
> Rgds,
> Om