tahirih
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER