I believe something like this should work
https://www.sqlservertutorial.net/sql-server-basics/sql-server-update-join/
Using an inner join.
Let me know if you need help.
C
On Thu, 14 Jan 2021 at 22.52, Philippe Michel
wrote:
> A few weeks ago, someone reported two bugs (#59208 and #59209) in
A few weeks ago, someone reported two bugs (#59208 and #59209) in the
way match results are stored in the database.
I have committed a fix when for new entries, but existing ones have to
be updated directly in the database. The commands below should work for
sqlite3 but I think it should be