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 joi

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)