Archives of the TeradataForum
Message Posted: Tue, 16 Dec 2003 @ 15:36:52 GMT
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,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|