Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Joins.
Message
From
19/11/1999 15:00:43
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00293161
Message ID:
00293255
Views:
22
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform