Subject Re: [firebird-support] Tables "on the fly" in Firebird?
Author Ann W. Harrison
Aaron Abend wrote:
> SQL Server allows you to create a table "on the fly" and select from it, as
> in...
> Select count(*) from (select mycol from mytable where ...) VirtualTableName

The "select ... from (select...)" syntax is called derived tables and is
supported in Firebird 2.0. The alternative is to restructure the query
- where possible - into joins or create a view of the inner select.