Archives of the TeradataForum

Message Posted: Thu, 12 Jun 2003 @ 17:08:45 GMT

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

Peter,

Why does the count of your left outer join return less than the number of rows in ETL_TEMP.XREF_VENDOR_TMP? The left outer join is basically the same thing as count(*) from this one table, so I do not think it should have returned 3993 but instead have 231226.

Also, your table DDL says columns not null, but your left join has "WHERE F.VENDOR_ID IS NULL".

Why/how is this?

As suggested, I am thinking you have nulls somehow in your data as this might explain some of your results. Could you modify your "NOT IN" sql statement to add WHERE XREF_VENDOR.VENDOR_ID IS NOT NULL to the derived query part.

--Jason

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