I got 2 same tables from 2 different databases. Table 1 database 1 changes everyday with new details. I update tble 2 database 2 with details which are in table 1 database1. Whats the easier way of updating table 2 frequently withought dublicating records.
You can use the Default view for Datatable 1 and get the unique rows and append that rows in second Datatable.