Sure, although really that's the same solution - doing an EXISTS or a JOIN will be roughly equivalent in performance.

What I was hoping for, was a version of this query which wouldn't require me to do two queries of the same table, and instead have it be done in one shot like the version which doesn't work.