Yes you can create pseudo tables and reference them in the outer query as
you have done.
Please reply to the whole group only!
"Mike Davies" <mpdmindless.com> wrote in message
> I'm trying to select from a subquery
> 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
> query is ...