The phrase FROM Donors INNER JOIN DonationRecords ON tells SQL to find matching records between the two tables, based on the expression that follows the key word ON.

If you only want to update values in table A when there are matching records in table B, then an inner join is the way to go. If you have calculations that need to vary based on optional data, the ...