You have at least two options, split the SELECT into more SELECTs, or you can wait for VFP9 which will have no limits.

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