[Teradata Database] [5464] Error in Join Index DDL, Outer table field is not in the SELECT list.

Database

[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

Tags (1)
1 REPLY
Teradata Employee

Re: [Teradata Database] [5464] Error in Join Index DDL, Outer table field is not in the SELECT list.

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).