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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update Query 1
Union Query 6
Query to duplicate a record with one field updated 0
Removing Primary Keys 1
Parameter in Union Query 1
Multiple Table Query Is Blank 1
Update Query Question 1
Query for Forecasting Fuel Usage 1

Back
Top