Archives of the TeradataForum

Message Posted: Thu, 08 Feb 2008 @ 01:18:48 GMT

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

After looking at my SQL again I have figured out want I needed to do:

     SEL B.*
     FROM ADHOC.RATES A
     INNER  JOIN ADHOC.RATES B
     ON A.RATEID = B.RATEID - 1
     WHERE .1653 BETWEEN A.AMOUNT AND B.AMOUNT ;

I needed to return SEL A.* instead of B.*

<Overlooked the obvious>

Thanks for your assistance!

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