Archives of the TeradataForum

Message Posted: Thu, 06 Sep 2012 @ 13:06:36 GMT

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

Hi

Can someone explain how is Table & Cloumn alias resolved in Teradata 14?

Does it take reference to the table id and column id stored in system tables to resolve the alias?

There was an upgrade done from Teradata 12 to Teradata 14 recently and all the database objects were migrated from V12 to V14 along with replicating the access & user rights at database level. We are seeing problem with column alias when trying to reference from the subqueries and the joins

Scenario: If the Alias name in the main SQL is the same as those used in subquery and the joins, the query is not giving any result.

However, if the alias name in main SQL is changed to some other name, then the result works fine.

Any information related to this will be appreciated

Thanks

Suman

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