Archives of the TeradataForum

Message Posted: Mon, 13 Nov 2007 @ 01:18:54 GMT

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

Latesh:

From what I seem to remember Todd Walter posting SEVERAL months ago and it makes sense, the only place you can create a table alias is in a FROM. An UPDATE may contain a FROM, but yours does not. Therefore, no alias is allowed for any table be it real or temporary and using the table name is required. With that stated, why are you bothering to join the column to itself in the first place? If the column you are using is unique, then of course it is going to be equal to itself - nothing accomplished whether it is aliased or not - this does not seem to make sense. Normally you have a table joined to itself, not a column in the same table joined to itself. In other words, you need to have a from with an alias and use the alias and the table name in the WHERE. Maybe it is pecular behavior due to pecular SQL?

Regards,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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