Archives of the TeradataForum
Message Posted: Mon, 11 Feb 2013 @ 13:31:51 GMT
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
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|