Professional Web Applications Themes

combine two select statement - Microsoft SQL / MS SQL Server

Hi guys, I have two select statement, each will return one cell select1: Select2 a b If I use Union, I will get Select1 a b I want so that I can get the result Select1 Select2 a b in the same table. Any help is appreciated. Jun...

  1. #1

    Default combine two select statement

    Hi guys,
    I have two select statement, each will return one cell
    select1: Select2
    a b

    If I use Union, I will get
    Select1
    a
    b

    I want so that I can get the result
    Select1 Select2
    a b
    in the same table.

    Any help is appreciated.

    Jun


    Junaili Lie Guest

  2. #2

    Default Re: combine two select statement

    select t1.col1,t1.col2, (select cols from select2)
    from t1

    ie put the second select as a subquery in the list of expressions for the first select, provided it only returns a single value.

    But without DDL I am just guessing!

    Mike John


    "Junaili Lie" <junaili_liehotmail.com> wrote in message news:#LjMZVaQDHA.304tk2msftngp13.phx.gbl...
    > Hi guys,
    > I have two select statement, each will return one cell
    > select1: Select2
    > a b
    >
    > If I use Union, I will get
    > Select1
    > a
    > b
    >
    > I want so that I can get the result
    > Select1 Select2
    > a b
    > in the same table.
    >
    > Any help is appreciated.
    >
    > Jun
    >
    >
    Mike John Guest

  3. #3

    Default Re: combine two select statement

    use JOIN

    "Junaili Lie" <junaili_liehotmail.com> wrote in message
    news:%23LjMZVaQDHA.304tk2msftngp13.phx.gbl...
    > Hi guys,
    > I have two select statement, each will return one cell
    > select1: Select2
    > a b
    >
    > If I use Union, I will get
    > Select1
    > a
    > b
    >
    > I want so that I can get the result
    > Select1 Select2
    > a b
    > in the same table.
    >
    > Any help is appreciated.
    >
    > Jun
    >
    >

    Bob Castleman Guest

  4. #4

    Default Re: combine two select statement

    But are probably answering different questions!

    Mike

    "Junaili Lie" <junaili_liehotmail.com> wrote in message news:O9m59qaQDHA.4024tk2msftngp13.phx.gbl...
    > Thanks to Mike and Bob.
    > Both solutions work.
    >
    >
    > "Junaili Lie" <junaili_liehotmail.com> wrote in message
    > news:%23LjMZVaQDHA.304tk2msftngp13.phx.gbl...
    > > Hi guys,
    > > I have two select statement, each will return one cell
    > > select1: Select2
    > > a b
    > >
    > > If I use Union, I will get
    > > Select1
    > > a
    > > b
    > >
    > > I want so that I can get the result
    > > Select1 Select2
    > > a b
    > > in the same table.
    > >
    > > Any help is appreciated.
    > >
    > > Jun
    > >
    > >
    >
    >
    Mike John Guest

Similar Threads

  1. Select-And-Update in one statement?
    By Ignoramus23298 in forum MySQL
    Replies: 1
    Last Post: May 19th, 07:02 PM
  2. select statement woes
    By megalith in forum Coldfusion Database Access
    Replies: 8
    Last Post: March 27th, 09:07 PM
  3. SP with Select statement
    By Gerald in forum ASP Database
    Replies: 3
    Last Post: November 27th, 03:38 PM
  4. help with SELECT statement
    By Chris Hohmann in forum ASP
    Replies: 2
    Last Post: August 19th, 05:10 PM
  5. SELECT statement
    By Simon in forum Microsoft SQL / MS SQL Server
    Replies: 23
    Last Post: August 18th, 01:12 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139