I have:

Table1 (large table with over 50,000 records)

table 2 (always a small table with 100 records or less)

I want add data of table 2 to table 1

if field table2.device_id already exists on table1.device_id

= messagebox (Record already exists)

What is the best way to do such append ?