Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 11 Feb 2003 @ 20:26:45 GMT


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


Subj:   Re: I'm stumped...case logic on a left join subquery vs. case logic on a select query
 
From:   Ken Hansen

My reading of the error statement is that Tdata does not understand the "pc" that follows the bracket and if that is corrected it would probably not understand the following "pd".

Not elegent but a tactical solution, that might be acceptable if this is a one-off, is to create a temp table from version 1 and then join to that temp_table.

Ken



     
  <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: 15 Jun 2023