Thanks a lot!



--- In Firebird-Java@yahoogroups.com, "Thomas Steinmaurer" <ts@i...>
wrote:

> > 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