Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 13 Sep 2002 @ 15:51:44 GMT


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


Subj:   Improper column reference in the search condition of a
 
From:   Burton, Bruce

I am doing a simple left join on a table:

left join mktg_temp.agent x on SBSCR_SETUP_DEALR_CD= x.agent_code and SBSCR_MRKT_CD=x.market_code


I am getting this error in Queryman:

"3782: Improper column reference in the search condition of a joined table"


the tables are joined by two columns. there is a difference between the data definition between one of the joined columns where one column is varchar5 and the other is char6...only a guess.


Thanks,

Bruce



     
  <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