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 ...

I'm a total SQL n00b, so forming complex SQL statements is kind of new to me. I'll give your query a shot tomorrow and let you know how it goes.<BR><BR>Thanks!

LastName nvarchar(20)) As Json Inner Join dbo.Customers As cust On cust.LastName = Json.LastName; Of course, looking back at the Insert statement, the simplest solution is just to shove JSON data into ...

The left join updates all rows in table A. Inner join only updates rows in table A where there is a matching ID in table B. You're working with different row sets.