| Subject | Re: select from select |
|---|---|
| Author | ben_ata |
| Post date | 2003-11-21T23:20:21Z |
--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
wrote:
Basically it's "a view on the fly"
The above statement could be re-written as
CREATE VIEW t2 AS SELECT * FROM T1;
SELECT * FROM t2;
Sometimes it is a a very convenient way, to make statements more
readable, or if you don't want to bother creating a view.
wrote:
> > Hello to everyone,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;
> >
> > Kind regards,
> > Stefan Koronka
>
> interesting - which SQL servers understand this SQL and what does it
> plain language?Servers supporting this: Oracle, PostgreSQL, HSQLDB, SQL Server
>
Basically it's "a view on the fly"
The above statement could be re-written as
CREATE VIEW t2 AS SELECT * FROM T1;
SELECT * FROM t2;
Sometimes it is a a very convenient way, to make statements more
readable, or if you don't want to bother creating a view.