Hello,
>What is the difference between:
>SELECT table1.* ;
>FROM table1 ;
>INNER JOIN table2 ;
>INNER JOIN table3 ;
>ON table3.key2 = table2.key2 ;
>ON table2.key1 = table1.key1
>and
>SELECT table1.* ;
>FROM table1 ;
>INNER JOIN table2 ;
>ON table2.key1 = table1.key1
>INNER JOIN table3 ;
>ON table3.key2 = table1.key2 ;
The difference described in VFP5FAQ.TXT that can be found in your VFP
directory... In short, the difference is how the parser process those SQL
statements. The right one is latter. But I prefer to not use this syntax when I can use standard...
* Human is a question asked by birth and answered by death. Machine is another kind of question with another kind of answer