Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 13 Sep 2002 @ 17:24:55 GMT


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


Subj:   Re: Improper column reference in the search condition of a
 
From:   John Grace

Bruce,

What are SBSCR_SETUP_DEALR_CD and SBSCR_MRKT_CD? Are these columns in a table? If so what table? I think this needs to be clarified. Can you provide more SQL? OR let me know and I can email you a working SQL left outer join statement.

All the database platforms we work with are somewhat finicky when it comes to referencing columns and use of aliases in sql statements that use the outer join syntax, so you need to be very careful.

Column datatype would not produce this error, but it may impact query performance. Check the explain, I am not sure if an explicate conversion is required.

John Grace
Geppetto's Workshop



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016