Hi,

In my application, we have to work with 2 databases.

1. First database(D1) is where we get all the updated information.
like userID, emailID, status, dept etc. lets call table "ABC", which can contain more than 4 Lakhs record.

2. Second database(D2) is where we need to update to the table "XYZ" by retrieving data from D1."ABC". Table "XYZ" can contain "25 to 50 thousand records".

Problem:
Now, I need to update status information in table D2."XYZ" by retrieving status field data from table D1."ABC" using "userID" as primary and foreign key.

May I know the best approach to update the status information of 50,000 records of database (D2) from 4 Lakhs records of database (D2)?

Thanks,
Chinnu

I think the best would be to use an UPDATE statement.