could you use a stored procedure?
~M

>>>>Mainly, what I meant with "R/O" is that you are not using the data in a view, which will send the data back to the underlying table. For a view, splitting the query into pieces may be unfeasible.
>>>
>>>Yes, it's R/O.
>>
>>Well, then, I would say it is worth-while to break it into pieces. Especially, to join only two tables at a time.
>
>No luck so far :( It's still slow in network :( It's much quicker for the local database.