Hey Scott, I get it. You were trying to show how different syntax might yield same results...perhaps to expose underlying logic of the original query I posted in the opening post. But, I'm still working through Moden's post and for me it's eye opening to see the impact of choosing one syntax over another. Crazy how much you have to know SQL to be thinking about performance and syntax at same time (as I never think about performance - really truly)...very helpful for me in the long run.

Where I've worked, just getting at the data, and bringing it to the light of day, has been the rewarded effort. I have yet to encounter a developer who will tell me that my queries totally suck and why didn't I write them optimally. I can't wait...:-(