> Does firebird support inner join?

Yes.

> I tried the query:
>
> select count(*) as "c0" from (select distinct "T_TEMPO"."ANO" as "c0"
> from "T_TEMPO" as "T_TEMPO") as "init"

That's not an inner join - that's a derived table.


With regards,

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