Mike,

>Thats a very good question, and I need to ask the person I'm asking this on behalf of, though I'm interested in the answer too. I guess that the correlated subquery is the only way to go.

No, see erics reply. A self join would do also. I'm not sure about performance differences though...

Walter,