Update Queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Two different databases or two different tables?

The basic query would be the same

UPDATE Table1 Inner Join Table2
 
Back
Top