>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.