hi,

thanks for ur reply.

i also tried this query as bellow.becoz i have to check 2 primary columns

[

insert into Source ( batch_id,First_Name,Last_Name,Sid,Mid)

select s.batch_id,s.First_Name,s.Last_Name,s.Street_Address1,s.DOB,s.Sex,s.Subsid,s.Mid from

Source s WHERE not exists

(select f.batch_id,f.First_Name,f.Last_Name, f.Sid,f.Mid from

destination f where f.batch_id=s.batch_id)

]

but, there is problem

1) suppose at the first time, the destination table doesn't have any data.and the source table have new record for a person and updated record for the person then, it insert all the data into destination..

so,i think, i have to insert row by row..

how can i implement this ??