Archives of the TeradataForum

Message Posted: Mon, 11 Feb 2013 @ 13:31:51 GMT

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

If you have a filter condition on the WHERE clause that references a column in the LEFT-joined table (FDW_BT.SITE), it might cause this 'behaviour'. If that's the case, you would need to add a "OR site.ColumnA IS NULL" condition to your WHERE (or something similar), to get around that.

Johannes de Wet
Data and Information Services
Unum

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