Archives of the TeradataForum

Message Posted: Tue, 16 Dec 2003 @ 15:36:52 GMT

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

Hi Rachana:

You are writing your query as a product join because you are dynamically including the RMU_SCHED_MMS_GET_MISSION_RES table without a join condition.

You are using the RMU_SCHED_MMS_GET_MISSION_RES, GMR and TL tables.

In Teradata, when you alias a table, you must use the alias. This is what allows a self-join with one table. The other thing that appears to be a problem is that your alias is on the RMU_SCHED_MMS_GET_MISSION_RES1 table and you are naming the RMU_SCHED_MMS_GET_MISSION_RES table in the SELECT. Regardless, Teradata allows you to dynamically access a table without a FROM and this is what you are doing.

For instance, you can write a query without a FROM as in the following:

SELECT my_table.*; /* the same result as SELECT * FROM My_table; */

So, you either need to use the alias name to qualify all your column references, or get rid of the alias.

Hope this helps,

Michael Larkins
Certified Teradata Master

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