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