Thanks! The real life query is a little bit more complicated than what I described in my question, but I think this will work perfectly.