>>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.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)