Archives of the TeradataForum

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

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

The DISTINCT, the WHERE, and the Inner joins could all cause you to lose rows.

Change the INNER to LEFT OUTER - that will avoid problems of Null/Missing values.

Mike Dempsey

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