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
 
Back
Top