Archives of the TeradataForum

Message Posted: Wed, 14 Dec 2011 @ 21:35:08 GMT

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

Could it be that you are losing data due to the inner joins? If there is no match on the join condition then the row will not progress. If you want everything from the base table then you should use that as the driving table and use outer joins to the other tables. This way everything from the driver table will make it into the new table.

Regards,

Martin

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