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.