Hi,

> I want to perform a subquery like the simple following one:
>
>
> select K.*
> from (select *
> from tablename
> where field1=val1) K

> It always raise an error at the select statement next to from.
> How can I do that ?

Derived tables are not yet supported on Firebird.
Maybe, Creating an VIEW could workaround your problem.

Regards,
Arno