In fairness there's nothing weird about that, it being just a typical correlated subquery. I'd quite possibly do it that way.