Hi,

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

Those are called derived tables and aren't supported yet.

Maybe you could workaround it with :

SELECT
Count(DISTINCT sample_type)
FROM
samples


Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird open source database (based on IB-OE) with many SQL-99 features :
http://www.firebirdsql.org
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/

Support list for Interbase and Firebird users :
firebird-support@yahoogroups.com

Nederlandse firebird nieuwsgroep :
news://80.126.130.81