Update Queries

[Kay]

I am working with two different databases; however, the newer database contains information needed from the older database. Is there a way to copy the information I need from one database to another.

Example
The primary key is the PROV ID#, I need to copy there address into the current database without manually typing them.

 

[John Spencer (MVP)]

Two different databases or two different tables?

The basic query would be the same

UPDATE Table1 Inner Join Table2