Archives of the TeradataForum

Message Posted: Thu, 12 Oct 2006 @ 12:46:28 GMT

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

Sirisha,

INSERT..SELECT ignores the duplicate rows.

If you are expecting duplicate rows, you may want to create the table as MULTISET table.

Thanks,

Vinay Bagare

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