>Hello Hilmar
>
>Thank for your reply. (see my reply to Sergey).
>
>Interesting to know with joining table 2 and 3. i'll put this in my querry help!
Oh, one more thing. You can join up to 9 (or was it 10?) tables, but if it is for a report, or some other purpose other than a view (where you need to write the data back to the underlying tables), you will often get a much faster performance if you do the join in several commands. I once split a 9-table query into several pieces, adding one table at a time to the previous result. The time required to execute the query, over the network, was reduced from 50 seconds to 2 seconds. Since then, I seldom join more than two tables at a time.
I tried other approaches, like using the FORCE clause, but I could never get near the speed I obtained by separating the queries.
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)