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