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.


Regards,


Ann