Professional Web Applications Themes

Select From SubQuery - Microsoft SQL / MS SQL Server

Yes you can create pseudo tables and reference them in the outer query as you have done. -- HTH, SriSamp Please reply to the whole group only! "Mike Davies" <mpdmindless.com> wrote in message news:u5HdfVHQDHA.2460TK2MSFTNGP10.phx.gbl... > I'm trying to select from a subquery > i.e > > select count(tbl1.id) from > ( > select id from table1 > where ... > ) tbl1 > > I'm pretty sure this can be done as I think I have done it before > > I realise I could do this another way but this is only an example, my actual > query is ...

  1. #1

    Default Re: Select From SubQuery

    Yes you can create pseudo tables and reference them in the outer query as
    you have done.
    --
    HTH,
    SriSamp
    Please reply to the whole group only!

    "Mike Davies" <mpdmindless.com> wrote in message
    news:u5HdfVHQDHA.2460TK2MSFTNGP10.phx.gbl...
    > I'm trying to select from a subquery
    > i.e
    >
    > select count(tbl1.id) from
    > (
    > select id from table1
    > where ...
    > ) tbl1
    >
    > I'm pretty sure this can be done as I think I have done it before
    >
    > I realise I could do this another way but this is only an example, my
    actual
    > query is much more complex so I cant do it in a single query.
    >
    >

    SriSamp Guest

  2. #2

    Default Re: Select From SubQuery

    But I get a syntax error when I do this? Can you provide an example?


    "SriSamp" <ssampathsct.co.in> wrote in message
    news:ejJzlcHQDHA.3192tk2msftngp13.phx.gbl...
    > Yes you can create pseudo tables and reference them in the outer query as
    > you have done.
    > --
    > HTH,
    > SriSamp
    > Please reply to the whole group only!
    >
    > "Mike Davies" <mpdmindless.com> wrote in message
    > news:u5HdfVHQDHA.2460TK2MSFTNGP10.phx.gbl...
    > > I'm trying to select from a subquery
    > > i.e
    > >
    > > select count(tbl1.id) from
    > > (
    > > select id from table1
    > > where ...
    > > ) tbl1
    > >
    > > I'm pretty sure this can be done as I think I have done it before
    > >
    > > I realise I could do this another way but this is only an example, my
    > actual
    > > query is much more complex so I cant do it in a single query.
    > >
    > >
    >
    >

    Mike Davies Guest

  3. #3

    Default Re: Select From SubQuery

    I tried a similar query:

    SELECT COUNT(m.au_id) FROM
    (SELECT au_id FROM authors WHERE contract = 0) m

    And I get the result. What is the syntax error that you are getting??
    --
    HTH,
    SriSamp
    Please reply to the whole group only!

    "Mike Davies" <mpdmindless.com> wrote in message
    news:%23jWsngHQDHA.2676TK2MSFTNGP10.phx.gbl...
    > But I get a syntax error when I do this? Can you provide an example?
    >
    >
    > "SriSamp" <ssampathsct.co.in> wrote in message
    > news:ejJzlcHQDHA.3192tk2msftngp13.phx.gbl...
    > > Yes you can create pseudo tables and reference them in the outer query
    as
    > > you have done.
    > > --
    > > HTH,
    > > SriSamp
    > > Please reply to the whole group only!
    > >
    > > "Mike Davies" <mpdmindless.com> wrote in message
    > > news:u5HdfVHQDHA.2460TK2MSFTNGP10.phx.gbl...
    > > > I'm trying to select from a subquery
    > > > i.e
    > > >
    > > > select count(tbl1.id) from
    > > > (
    > > > select id from table1
    > > > where ...
    > > > ) tbl1
    > > >
    > > > I'm pretty sure this can be done as I think I have done it before
    > > >
    > > > I realise I could do this another way but this is only an example, my
    > > actual
    > > > query is much more complex so I cant do it in a single query.
    > > >
    > > >
    > >
    > >
    >
    >

    SriSamp Guest

Similar Threads

  1. MySQL subquery in select
    By Kasper K in forum MySQL
    Replies: 6
    Last Post: July 12th, 02:24 PM
  2. Subquery
    By Ruszaj in forum Coldfusion Database Access
    Replies: 2
    Last Post: November 2nd, 04:50 PM
  3. using list in subquery
    By spacehog in forum Coldfusion - Advanced Techniques
    Replies: 3
    Last Post: March 9th, 11:23 PM
  4. SQL subquery question
    By derek in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: July 9th, 06:48 PM
  5. subquery with more than 1 fields
    By Calvin in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: June 30th, 05:53 AM

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