>SELECT Route, ClassType, Family, > SUM(PrevPassngers) AS PrevPassngers, MAX(PrevMult) AS PrevMult, ... > ... > GROUP BY 1,2,3 >>
>>Route Class SType Family PrevPassngers PrevMult PrevNumTrips CurrPassengers CurrMult CurrNumTrips >>0588 D G 386 1.75 676.79 >>0588 D G 147 1.00 147.00 >>0588 D G 194 1.00 194.00 >>0588 D G 313 1.00 213.00 >>0011 C B 33 1.75 57.86 >>0011 C B 1 1.00 1.00 >>0016 C E 675 1.75 1183.51 >>0016 C E 3 1.00 3.00 >>0016 C E 17 1.00 17.00 >>0016 C E 10 1.00 10.00 >>... >> >>and need to condense/combine them into 1 rec for each Route/ClassStype/Family combo, i.e. >> >>Route Class SType Family PrevPassngers PrevMult PrevNumTrips CurrPassengers CurrMult CurrNumTrips >>0588 D G 386 1.75 676.79 554 1.00 554.00 >>0011 C B 33 1.75 57.86 1 1.00 1.00 >>0016 C E 675 1.75 1183.51 30 1.00 30.00 >>>>Is there a quick SQLish way of doing this without having to loop and append and accumulate and all that?