Hi,

> It doesn't appear so -- in 1.5, "select * from (select * from bar)"
> doesn't work. In the what's new for FB 2, they list derrived tables as
> something new.
>
> Is there a compilation option that enables derrived table support for
> 1.5?

Ann explains the difference between a "sub-query" and a "derived table"
although some vendors call "derived tables" "sub-queries". Confusing isn't
it :-)

but...

1) This query has a sub-query (long time supported by FB):

SELECT
(SELECT t2.F1 FROM Table2 t2 WHERE t2.ID = t1.ID)
FROM
Table1 t1


1) This query has a derived table (will be in FB2):

SELECT
*
FROM
(SELECT t2.F1 FROM Table2 t2)


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