On Sat, 15 May 2004 11:39:46 +0000 (UTC), j_j_e_m wrote:

> Hello,
> How can I get a select-in-the-from clause to work? I mean something like:
> select count(*) from (select distinct sample_type from samples)
> Any help will be appreciated :o)

This is not legal syntax in IB/Fb, as you have found.
Maybe you can use a VIEW for the inner select, or rewrite as a JOIN in
other cases?


--
Aage J.