Archives of the TeradataForum

Message Posted: Thu, 12 Jun 2003 @ 16:35:04 GMT

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

This may work

SELECT COUNT(*)
FROM ETL_TEMP.XREF_VENDOR_TMP TP
WHERE TP.VENDOR_ID
NOT EXISTS (select * FROM ETL_TEMP.XREF_VENDOR TPP WHERE
TPP.VENDOR_ID=TP.VENDOR_ID);

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