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. Now if you said something like: ...