SQL Query

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • may_sapak1234@yahoo.com
    #1

    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
    */
    Tags: None
    • Om
      #2
      Re: SQL Query

      On Nov 15, 10:14 am, may_sapak1...@y ahoo.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

        Comment

        • newbie
          #3
          Re: SQL Query

          thanks a lot

          On 15 Nob, 17:22, Om <bubu.prak...@g mail.comwrote:
          On Nov 15, 10:14 am, may_sapak1...@y ahoo.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

            Comment

            Previous template Next
            Working...