My thought was that the end result in table A would be the same on either approach - i.e. 1 not added to anything (inner join) is the same as 1 + 0 (left join with isnull ()) ...