Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

Subj:   Re: Teradata query output
From:   Michael Larkins

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
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019