Archives of the TeradataForum

Message Posted: Wed, 16 Feb 2005 @ 17:15:27 GMT

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

The behavior you describe follows ANSI SQL rules as to how NULL values are to be handled for NOT IN (subquery). An alternative is to use NOT EXISTS. Check the Teradata SQL Reference (V5 - Functions & Operators) for more detail.

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