--- In ib-support@y..., Helen Borrie <helebor@t...> wrote:

> At 12:00 PM 20-09-02 +0000, you wrote:
> >Hi
> >
> >Can I do something like:
> >
> >Select Count(*) from (Select * from TABLE1 where FIELD=180);
> No - but why would you want to?
>
> Won't this give you the answer you want?
>
> select count(*) from table1 where field=180

Yes, but this was just an simplified exampel.

I have other situations where I would like to do something like the
above.
I can do in another way, and was therefor just wondering.

Michael

>
> heLen