>I'm going to disagree with my compatriots who posted earlier on this. If you don't specify an ORDER BY clause, the records are returned in the natural order of the table. In VFP's case, by record number.
>
>This is not to confused by order of entry. If, for example, you reuse deleted records, then newer recrds may appear before older records because the record number is lower.

This seems odd to me. I thought I had read that ANSI SQL does not guarantee the order if no ORDER BY clause is specified. I realize that VFP SQL is not 100% ANSI compliant (at least as far as I know), but what happens if a WHERE clause is used in the view that takes advantage of Rushmore?