Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Increase number of JOINs
Message
From
14/09/2004 04:21:08
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00941815
Message ID:
00941819
Views:
20
> 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
Previous
Reply
Map
View

Click here to load this message in the networking platform