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

For years now there's been a constant war between Microsoft supporters and Oracle supporters. Oracle has these features, SQL Server has these features, etc. But that's not really where the real ...

In this SQL Server tip, Arthur Fuller explains the effects of NULLs, and the different results obtained by inner and outer JOINs.