Subject Re: [firebird-support] Re: Subquery in "from" clause of Select statement
Author Thomas Steinmaurer
> 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