Madhivanan (9/24/2008)

---

insert into test2

select * from test1 as t1

where not exists(select * from test2 where pk=t1.pk)

thanx for this....

actually what if existing entry is updated....???