update

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

Guest

I have two tables, with almost equal values except the entry for one field is
blank.

how do i update the blank values in one table and replace those said blanks
with the entry from the other table for the same record
 
Do you have a common Field that uniquely identifies Record in both Tables?

If you do, you can use and Update Query like: (RecordID for example):

UPDATE tblA INNER JOIN
tblB ON tblA.RecordID = tblB.RecordID
SET tblA.RequiredField = tblB.RequiredField
 
You must log in or register to reply here.

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

create table from template table 0
one to many 1
Update query with if else condition (need to refer to cell indexes 2
Join Queries Involving a blank field 5
#error - Blank 3
Easy question -update query 5
Nested select/update 2
Append two tables into a query 1

Back
Top