Archives of the TeradataForum

Message Posted: Tue, 25 Nov 2003 @ 12:55:45 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

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


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Archives

2003 Indexes

Last Modified: 15 Jun 2023