Null means "undefined" in SQL, so numerous online services don't think Christopher Null exists.

I get that for case 2 vs 3, but wouldn't the inner join avoid the null propagation by not attempting to add the null in the first place - if there is no record in table b, then don't attempt to ...