 |
 |
Archives of the TeradataForum
Message Posted: Tue, 25 Nov 2003 @ 12:55:45 GMT
| Subj: | | Re: Teradata select error |
| |
| From: | | Dieter Noeth |
| | Especially for Vivek Pandey, I made a stupid error posting non-ANSI "Teradata" version naming the derived table together with
columns. | |
| | "SELECT * FROM (SELECT A,B,C FROM ...) AS X (id1,id2,id3)". Be sure the syntax is correct. | |
This syntax *is* ANSI SQL and you're absolutely right: both versions are supposed to work without errors.
Dieter
| |
