Archives of the TeradataForum

Message Posted: Tue, 29 Jul 2008 @ 15:52:52 GMT


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

Subj:		Re: Rows not found during join

From:		Michael Larkins

Hi Ben:

Since you are working with a UPI, the duplicate row creation should not be an issue. Your query did a NOT IN and then a tiny sample - not sure what that proves. So, my question would be: how many rows do you get when you run a join between these two tables?

Regards,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor