Archives of the TeradataForum

Message Posted: Thu, 02 Dec 2004 @ 20:55:51 GMT

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

Tony:

I too remember having seen the reference of an alias for the update table in the manuals for older Teradata releases. However, now the only place you can alias a table name is when it is referenced in the FROM (more ANSI standard this way).

You are now required to use the name of the table being updated to qualify the column name.

Hope this helps,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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