Subject Re: [Firebird-Architect] inner join
Author Martijn Tonies
> Does firebird support inner join?


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