Archives of the TeradataForum

Message Posted: Wed, 22 Mar 2006 @ 17:39:11 GMT

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

For me it is quite clear that if you need to have data from two rows in only one row you must do a self join.

The join condition is another thing ...

For generating the "sequence" number for the join you could use an OLAP function. SUM perhaps or maybe RANK. I do this all the time for loading history tables.

Atenciosamente,

Cesar Ureta

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