> Thomas,
>
> the SQL below was writte n justo to clarify my question. I know the
> correct form of to do this. My question is: Subquery is supported in
> "from" clause of "select" in FB 1.5.3?

If you mean derived tables, that said, something like this:

select * from (
select * from t1
)

then the answer for Firebird 1.5.x is no. Derived tables is a new
feature in Firebird 2.



--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com