Table_1:

Col 1 Col 2 Col 3 Col 4 Col 5 Col 6 Col 7 Col 8 Col 9
(PK1) (PK2) (PK3) (PK4) (PK5) (PK6) blah blah blah
1 A raj 123 Abc 321 ….. …… ……
1 A raj 123 xyz 321 ….. …… ……


I want to select data from the above table and insert into the same table with a change in PK5 and PK6. the code that I’m using is something like this:
INSERT INTO table_1 t1
SELECT t2.pk1, t2.pk2, t2.pk3, t2.pk4, ‘mno’, 999, t2.blah, t2.blah,…………
from table_2 t2 where t2.pk4 in (123, 234)
and t2.pk6 = 321;

but I get error because the primary key is being duplicated, which is fair. This is what it is trying to do.

Col 1 Col 2 Col 3 Col 4 Col 5 Col 6 Col 7 Col 8 Col 9
(PK1) (PK2) (PK3) (PK4) (PK5) (PK6) blah blah blah
1 A raj 123 mno 999 ….. …… ……
1 A raj 123 mno 999 ….. …… ……

My question is, is there anyway to avoid these duplicate rows?????????