Access - Update Two Fields with One SQL Query

I have two Tables A and B. I would like to update the values from 2 fields in B into A. The following works for one field, and I have tried many combinations with no luck.

UPDATE A INNER JOIN B ON (A.Name_L=B.Name_L) AND (A.Name_F=B.Name_F) SET A.[Mtg Date Initial Audit] = B.Mtg;

Your assistance is most appreciated.

Thanks
tahirihAsked:
Who is Participating?
 
MNelson831Connect With a Mentor Commented:
UPDATE A INNER JOIN B ON (A.Name_L=B.Name_L) AND (A.Name_F=B.Name_F) SET A.[Mtg Date Initial Audit] = B.Mtg, a.[otherfieldname] = b.[otherfiledname], a.[thirdfieldname] = b.[thirdfieldname], etc
0
 
tahirihAuthor Commented:
Thank you, just what I was looking for. I had used an "AND" operator in between, unsuccessfully.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.