>Sergey/Cetin
>
>The following MB SQL does manage to get the data I want, in the correct order. Problem is it still gets all gen's for those routes that have more than one. I just can't figure out how to get rid of the "older" gens.
>
>
>Select Rte_No, MAX( ASC( Rte_Let)) "maxGen", Directn, Stop, SeqNo, Time, RunOrder
> from RZStop
> where Zone = 1
> into csrZonesServices NoSelect
> group by rte_no, maxGen, stop
> order by Rte_No, Stop, maxGen, Directn, SeqNo
>
>
>I have to ASC() the gen in order to MAX() itr as MAX() only works on numerical fields in MB.
>
>Terry
I prefer to say 'no way' :) Probably it doesn't support having clause (as if I can think what to add if that did:)
Cetin