General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Appending or inserting from other table
Environment versions
Network:
Windows 2008 Server
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 ?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only