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.