>Jay,
>
>Next you want to eliminate the HAVING clause as HAVING is always slower than WHERE, and what do you get ... the original query with the subselect in it.

As you say, what implementation you select depends on your goals at that moment. One provides probably better performance, the other gives more logical flexibility.

Jay