Archives of the TeradataForum

Message Posted: Wed, 05 Nov 2003 @ 20:19:29 GMT

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

Can you join the two tables and fetch using only one cursor?

You would have two while loops where the outer loop iterates thru the condition for C1 and the inner loop that iterates thru the condition for C2.

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