All Forums Database
robing9 1 post Joined 10/15
09 Oct 2015
[Teradata Database] [5464] Error in Join Index DDL, Outer table field is not in the SELECT list.

Hi 
 
I am new to teradata and I am trying to create a outer join index. I am getting an error as mentioned below. I have given all columns in the outer table in the SQL still getting this error
[Teradata Database] [5464] Error in Join Index DDL, Outer table field is not in the SELECT list.
 
Eventually i gave the query, Still getting the same error. We are having a slow performance query (with spool error) thats why i thought of creating one index.

CREATE JOIN INDEX AX AS

SELECT  

      fn.*

,fl.Notnullcolumn

 

FROM   tbls.A fl

left outer join tbls.B fn

on fl.Joinkey = fn.Joinkey

 
It will be great help if to get any solution.
 
REgards
Robin
 

Fred 1096 posts Joined 08/04
12 Oct 2015

You would have to include fl.JoinKey (join column from the outer table) in the SELECT list, along with a "NOT NULL" column from fn (the inner table).

You must sign in to leave a comment.