Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Joins.
Message
De
19/11/1999 15:00:43
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00293161
Message ID:
00293255
Vues:
21
>I've been thinking, which SELECT statement is better for readability and optimizing? Since the 2.x era i've been modeled into using the WHERE statment.
>
>SELECT * ;
> from a,b,;
> b outer join c on b.key2=c.key2
> where a.key1=b.key2
>
>OR
>
>
>SELECT * ;
> from a inner join b on a.key1=b.key1,
> b outer join c on b.key2=c.key2

I've had statments like the first one that ran slowwwww in VFP. When I recoded to use the JOIN syntax, they were fast, like I expected.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform