>>Thanks to All
>
>Peter;
>
>Breaking up a query is also a good exercise even if the maximum number of tables is not a direct issue. Many times breaking a multi table Select statement into parts will render better performance if done correctly.
>
>Tom
As an illustration, in one case I joined 9 or 10 tables. Over the network, it took me 50 seconds to get the desired results. As soon as I added the tables one at a time (with different SELECT statements), I reduced the time to 2 seconds.
Hilmar.
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)
