|
1.3. The order of the SELECT, INTO, FROM, WHERE, GROUP BY, HAVING and ORDER BY clauses is fixed in Transact SQL, but arbitrary in FoxPro.
For example, in FoxPro, all of these examples are valid:
Select a.F1,b.F2, ... From table1 a Join table2 b On a.FF=b.FF Order By 1 Group By a.F1
Select a.F1,b.F2, ... Order By 1 Group By a.F1 From table1 a Join table2 b On a.FF=b.FF
Select a.F1,b.F2, ... Order By 1 From table1 a Join table2 b On a.FF=b.FF Group By a.F1
Using our tool, all of the preceding examples would be replaced with the following ordering:
SELECT A.F1,B.F2, ... FROM TABLE1 JOIN TABLE2 ON A.FF=B.FF GROUP BY A.F1 ORDER BY 1
back
to features list
|
