Remember that to get the fastest possible response, you need appropriate indexes. The index must match the expressions you use in the WHERE and JOIN conditions. And try each query separate before you join them. Use sys(3054) to check the optimizing level.

>Tore,
>
>Thanks for the response. I will try this and see what happens.
>
>Thanks again!