Archives of the TeradataForum

Message Posted: Thu, 12 Jun 2003 @ 17:03:57 GMT

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

Could it be that Vendor_id is NULL for some entries in ETL_TEMP.XREF_VENDOR or in ETL_TEMP.XREF_VENDOR_TMP, because then the query has problems

Maybe changing the subquery to

(select VENDOR_ID FROM ETL_TEMP.XREF_VENDOR
where Vendor_id is not NULL
group by 1)

helps. If you check this I would appreciate to hear if it worked?`

Hope it helps

markus

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