Posted by newbie on 11/15/07 11:05

thanks a lot

On 15 Nob, 17:22, Om <bubu.prak...@gmail.com> 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

• Next in forum: tuning stored procedure, variables and different optimisers
• Prev in forum: Re: SQL Query
• Thread view: Re: SQL Query

[Reply to this message]