Help with SQL

itsonlyme44 · #1 (**permalink**) 07-16-10, 10:55

Running DB2 on Windows V9.5

Have two identical tables in different schemas with different row counts and duplicates.

I need to insert from one table into another and replace duplicates???

n_i · #2 (**permalink**) 07-16-10, 11:18

You should be able to do it with the MERGE statement.

Lenny77 · #3 (**permalink**) 07-16-10, 12:25

In some DB2 versions MERGE doesn't exist:

Code:

Insert     into  table2  t2
select  * from table1  t1
where 
not exists (select 1 from table2 t3 where t3.clm1 = t1.clm1)

Lenny

Internet Services

Web Development

Digital Marketing

Consumer Tech