>Is there a way to Select...Distinct from a table and have the resulting records be un-ordered, or following the natural order of the source table? I have tried select ... Distinct and also Select...Group By and the results are always sorted.
>
>TIA,
Jeff,
When you don't specify ORDER BY clause VFP is free to return records in any order. You should not relay on the order of records returned in this case. Here's how you can specify the order you want.
SELECT *, RECNO() AS RecordNo ;
FROM mytable ;
INTO CURSOR crsNumbered
SELECT DISTINCT ... ;
FROM crsNumbered ;
ORDER BY RecordNo
--sb--