>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