Subject | RE: [firebird-support] select from select |
---|---|
Author | Alan McDonald |
Post date | 2003-11-21T11:42:06Z |
> Hello to everyone,interesting - which SQL servers understand this SQL and what does it mean in
>
> 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
plain language?
Alan
(heaven forbid - no spreadsheets here)