Hi,

> This is not a subselect. This is called a derived table, FB 1.5 does
> not support this. AFAIK support for derived tables is planed for V2.0

The support for derived tables is guaranteed for FB 2.0, because the
code is already in place and it can be tested in the nightly builds of
FB 2.0.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)