Archives of the TeradataForum

Message Posted: Thu, 12 Oct 2006 @ 11:37:37 GMT

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

Hi,

I am trying the following sqls

     create table  temp1
     ( i int,j int);
     create table temp2
     ( i int,j int);

     insert into temp1
     (1,1);
     insert into temp1
     (2,2);

     insert into temp2
     (1,1);
     insert into temp2
     (2,2);

     insert into temp1
     sel * from temp2;

The result is no rows processed

     insert into temp1
     (2,2);

The result is Error 2802 :Duplicate row error in temp1

Why is that select statement is not giving Error 2802, but the insert statement is giving the error .

Regards,

Sirisha

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