>>Can you answer questions I asked in my previous message?
>
>
>Sorry, accidentally skipped your last message. I ran the procedural and it did work without a hitch. As far as subquery goes, it took about 5 seconds to run.
>
I don't think you can speed up this query so you'll have to stick to the procedural code.
--sb--