Another thing you could try (not sure if it will work), but, create local views that have portions of your full SELECT. For example, create a view that is based on 4 tables from the original SELECT. Create another view based on 5 tables from the original SELECT. Create these in a way that you can now create your SELECT based on the two views with a valid and appropriate join condition.

You might have to create 3 views to facilitate this, but I think you get the point.

Good luck.

>I have a SELECT SQL with more then 9 joins, & VFP (of course) gives me an error "SQL: Too many subqueries (Error 1805)". I hope that SYS(3055) can help me but :o(((((.
>So my question is: Is there any way to increase the joins?
>TIA
>
>P.S. I doubt, but I must ask :o))