> Hi,
>
> I am trying to execute this statement on Firebird:
>
> SELECT count(1)
> FROM
> (SELECT ID, CLIENT_TYPE, SERIAL_NO, ENABLED
> FROM BUSINESS_TYPES)
> ESTCOUNT
>
> It gives me the following error:
> Dynamic SQL Error
> SQL error code = -104
> Token unknown - line 3, char 2
>
> There is no information that such query will not work on FireBird
> database.
>
> Could you help me with some information on that issue?

A query from a derived table, like

SELECT ... FROM (SELECT ... FROM ...)

isn't supported by Firebird.



Best Regards,
Thomas Steinmaurer

The IB LogManager Product Family
Logging/Auditing Suite for InterBase and Firebird
http://www.iblogmanager.com