Isn't the inner join the only one that's redundant though, because it's the same as doing an equals check? (from a, b where a.b_id=b.b_id