> 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?
In Vfp9 you can join more than 10 tables. In previous versions omitting the JOIN keyword would work if you want Inner Joins only
SELECT * FROM t1, t2, t3 ... table15 ;
WHERE t1.key = t2.key And t2.key = t3.key ...
hth
-Stefan