Subject Re: [firebird-support] Subselect syntax in the FROM Clause
Author Thomas Steinmaurer
> Does anyone know what the correct syntax for having a subselect in
> the FROM clause is?
> e.g.
> SELECT alias.* from ( SELECT * from subtable ) alias
> or does firebird not allow subselects like this in the FROM clause.

This is called a derived-table and isn't supported in Firebird 1.5.x.
It's already in the Firebird 2 source tree though, so it will be
available in Firebird 2.0.

Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database and MS SQL Server
Upscene Productions