>>>>>>>>Sorry, it's two lines:
>>>>>>>>select * from table1 into cursor tmp1 order by customer,date
>>>>>>>>select * from tmp1 group by customer
>>>>>>>
>>>>>>>Ed:
>SELECT *;
> FROM Table1;
> GROUP BY CUSTOMER;
> ORDER BY ORDER_DATE
>
>However, because Isaac pointed out that the they weren't, the above will return inaccurate results, regardless of existing indexes. It's just another instance where making assumptions can get you into trouble, since the above will take the last *PHYSICAL* record in the table, rather than any ordering indication to the contrary.
>
>BTW, being the son of a musician, I'm wondering if there's any relation between your company and Better Music Insitute.
>
>George
George, isn't this exactly the reason Ed used two SELECT statements?
Barbara