A little background Is Null and IsNull() both find null values, but you won’t use them in the same way. You would use Is Null and Is Not Null in query expressions and SQL WHERE clauses.

and when I discover that it resulted in nulls he added isnull() on all columns ... same end result on tableA as per my understanding of SQL joins): ...