I have the following simple update statement in an Access (2021) query:
UPDATE Patrons INNER JOIN PatronsWork ON Patrons.PatronID=PatronsWork.PatronID SET Patrons.Zip = PatronsWork.Zip;
I've found numerous examples of update statements exactly like it on various web sites, and can think of no...