Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 19 Apr 2002 @ 11:46:32 GMT


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


Subj:   Re: SQL Question for all you experts out there
 
From:   Arthur Brown

Is CPCLMB.QCLMB001 a view or a table? If a view , is there any data type conversion being done on col AFVCPRO in the view? I'm just making a wild guess but if the above is true then ...

query 1's where condition is probably using the original datatype when doing the compare while query2's where condition could be doing the compare on whatever data type is returned from the view's select list in the derived table.

Either way , I believe the datatype of B1.AFVCPRO is different inside the derive table than it is on the outside. Try casting it.

Art.



     
  <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: 23 Jun 2019