I forgot to mention Oscar. His solution is identical to Sergey's.

Ben

>>Actually the one suggested by Sergey in message#1133767 is different from mine. His one is faster and better because it gets the resulting records directly from the subquery result without running the "IN" filtering operation against the master table.
>
>I will have to check it out again. Thanks