 |
 |
Archives of the TeradataForum
Message Posted: Sat, 28 Feb 2004 @ 10:25:23 GMT
| Subj: | | Re: Derived tables on V2R5 |
| |
| From: | | Dieter Noeth |
Victor Sokovin wrote:
| | 1. It looks like this new syntax form proved to be useful and it has been adopted by ANSI. In Oracle, derived tables are known as "inline
views" and have been around for some time. SQL Server supports them too. So, as a syntax form these "unnamed views" are likely to stay. I agree
with you here. | |
What do you mean by "new syntax"?
Derived tables have been part of SQL (at least) since SQL-92, but not part of Entry Level (Full Level in SQL-92).
Btw, in SQL:1999 it's still not part of Core SQL (Feature F591)
Dieter
| |
