|Subject||Re: [firebird-support] Subselect syntax in the FROM Clause|
> Does anyone know what the correct syntax for having a subselect inThis is called a derived-table and isn't supported in Firebird 1.5.x.
> the FROM clause is?
> SELECT alias.* from ( SELECT * from subtable ) alias
> or does firebird not allow subselects like this in the FROM clause.
It's already in the Firebird 2 source tree though, so it will be
available in Firebird 2.0.
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database and MS SQL Server