Archives of the TeradataForum
Message Posted: Fri, 19 Apr 2002 @ 11:46:32 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|