At 01:07 PM 12/18/2004, Garrett Smith wrote:

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

I wasn't clear. Derived tables are a new feature of
firebird 2. Subqueries have been around forever, as
in

select a, select max (b) from c as b, c from table


Regards,


Ann