Subject | select from select |
---|---|
Author | koronkas |
Post date | 2003-11-21T10:52:09Z |
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
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