> First of all, I am very delighted and impressed by Firebird.
> However, I encountered an issue which I couldn't solve.
> I need to do something like:
>
> SELECT * FROM ( SELECT * FROM T1 ) T2;
>
> (ok, this is a verry dummy sample, but basically this is what i need)
> For example, in IBExpert I get "invalid token" for the second select.
>
> The question is - am I missing something or this kind of construct is
> not (yet) possible in Firebird? (I am using now 1.5RC7)

Right. The so-called derived tables aren't supported yet.

--
Best Regards,
Thomas Steinmaurer

Logging/Auditing Suite for InterBase and Firebird
http://www.iblogmanager.com
Logging/Auditing Suite for Advantage Database Server
http://www.adslogmanager.com