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

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.

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!

Here is the SQL to compare the inner and outer JOINs: SELECT InnerOuter.T1.T1ID, InnerOuter.T1.NameAS Name1, InnerOuter.T2.T2ID, InnerOuter.T2.NameAS Name2 ...