Archives of the TeradataForum

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

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

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>>