You're right - this query doesnt make sense, because if he's left joining, he should at least do

where tableB.someCol != null

or something. Otherwise, the join is useless (or he should use an inner join)