Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 12 May 2011 @ 22:19:46 GMT


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


Subj:   Re: Use case statement to select the desired table
 
From:   Dempsey, Mike

I'm not sure what you are trying to do but case statements can not be used to select a table for a join. This has nothing to do with the query tool you are using - it is a database limitation.

(I'm not aware of any vendor's SQL that would allow you to do that)

If you can describe exactly what you are trying to do then someone may be able to offer an alternative.


Mike Dempsey
Teradata Client Tools



     
  <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