Thanks. I was hoping that there was some magic way to do this in one select, but I should have known better.