I decided to go with a view, although I think a subquery would have worked as well.