Hi,

> Why do I get an parse error with the following query:
>
> select count(*) as "c0" from (select distinct "T_TEMPO"."ANO" as "c0" from
> "T_TEMPO" as "T_TEMPO") as "init"

This is not a support list, but a list for people who design/talk about
the internals of the Firebird engine.

Subscribe to firebird-support@yahoogroups.com for your support questions.

Quick answer to your question:
Firebird doesn't support derived tables and that's what you're trying to do.


With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com