Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Increase number of JOINs
Message
De
14/09/2004 04:21:08
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00941815
Message ID:
00941819
Vues:
18
> 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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform