Table to table input 2

[kupe]

tblOne has records of addresses. tblTwo has them also. tblOne has some records that tableTwo doesn't have.

How could I say append to tblTwo any records from tblOne that tblTwo doesn't have, please?

 

[donvittorio]

As long as your tables have a unique identifier then you can use the following

insert into table2(id, col1, col2...)
select id, col1, col2...
from table1 t1
where not exists (select id from table2 t2 where t1.id = t2.id)

HTH

Steve

 

[TonyGroves]

Alternatively:
[tt]
INSERT IGNORE tbl2 SELECT * FROM tbl1[/tt]

 

[kupe]

Hi Steve(donvittorio) and Tony Groves

Brilliant. Thanks you so very much.

All the best