> 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
http://www.upscene.com