Archives of the TeradataForum

Message Posted: Thu, 12 Oct 2006 @ 12:22:42 GMT

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

I think your tables are getting created as SET tables. As SET table won't allow duplicate rows you are getting the Duplicate row error.

When you insert using Select statement it generally inserts all qualified rows (in your case no rows are qualified) and leaves all non- qualified rows. It won't give any error except giving the number of rows processed.

Thanks & regards

Srinivas Batchu

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