>>>>>>>>>>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
>
>Absolutely! Thank you Barbara. I couldn't reply during weekend and you defended my honest name (g).
>George, I am not a musician, and I don't know what is Better Music Insitute. My company is music licensing organization (btw the largest one).
Sounds close. Maybe over the years I changed the actual words to the acronym. BMI and ASCAP are mostly involved in music publication. Are you guys the same BMI?
George
George
Ubi caritas et amor, deus ibi est