> 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)

A workaround that you can do (that IMHO should be used only for extreme cases)
is to build a stored procedure (Firebird/Interbase procedures can result rows)
with a for select that suspends (fetch) all rows.

Valdir.