I have a database in Access that I am trying to fix (actually, I'm working on a copy of the original).
There are two tables, one with data input errors, and a second that is a copy of those errors, but fixed, if that makes sense. However the second table only contains 3 out of 14-ish fields, and the primary key is not among them.
I would like to update the first table with the information from the second, searching for records to update based on similarity between the Title field in both. The second has had some typos fixed throughout as well...
I know some SQL but not much.