Select From SubQuery - Microsoft SQL / MS SQL Server

[SriSamp]

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]

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]

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.
> > >
> > >

> >
> >

>
>