At 08:45 PM 6/08/2008, you wrote:

>Thank you for your reply Helen.
>Putting RecordStatus first is a good idea, I'll use it.
>
>Is there a way to make this query using JOIN?

No. Your subquery expression predicates an OR-ed condition. Subqueries can be interchanged with inner or outer joins (usually) when there is only one search condition.

>Would JOIN be faster than EXISTS?

Under some conditions it can be. It depends on a lot of factors and can really only be assessed by testing typical data. I tend to go straight for outer joins in preference to NOT predicates....

./heLen