>Simplicity would be a matter of opinion, I think... Anyway, when I ran the execution plan on the same data with these two statements in a batch and no Client table involved, it reported relative query costs of 61% for subquery approach and 39% for no subqueries. Since you have larger data at your hands you could check to see how they both escalate.

Thanks