I have two tables in my two databases. The two tables columns are same. So I need to update table1 data to table2. But the two tables are in two databases.
Currently I have the query to update data in the same database.
UPDATE Table1 INNER JOIN Table2 ON Table1.CODE = Table2.CODE
SET Table1.Marks = [Table2].[Marks];
This query is successfull in the same database. But Now I have two databases in location MyDocuments in C.
Database1 and Database2. So How can I do it two databases, update Table1 data from Database1 to Table2 in Database2 .