Which way would be the best Join to combine 2 records into 1 record for an insert to get rid of duplicate error on primary key. would that be a self join with the dupicate records combined into 1 record.