>>Single SQL and no intermediate results?:( This might work but slow:
>>

>>select distinct ;
>> r1.zone, r1.rte_no, r1.Gen, r1.direction, r1.time, r1.SeqNo;
>>  from RZStop r1, RzStop r2 ;
>> where r1.zone = r2.zone and r1.rte_no = r2.rte_no and r1.Gen > r2.Gen ;
>> order by 1,2,6

Cetin
>
>Can't do that either I'm afraid - aliasing the source table and using it twice in the same SQL.
>This is a real bummer of a language!!

OK final try:)
Create a view in VFP and mapbasic selects from that view?
Cetin