Subject RE: [firebird-support] select from select
Author Alan McDonald
> Hello to everyone,
>
> 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)
>
>
> Kind regards,
> Stefan Koronka

interesting - which SQL servers understand this SQL and what does it mean in
plain language?

Alan
(heaven forbid - no spreadsheets here)