To illustrate how a LEFT JOIN works, let’s simply change INNER JOIN to LEFT JOIN in our original SELECT statement, like this: SELECT Donors.DonorID,Donors.Donorname. DonationRecords.DonationAmt ...