>Hi all
>I have data similar to the following:
>OrderID, Date, FromLoc, ToLoc, Passengers, Rate
>I run the following query:
>select left(dtos(date),6) as CurMonth, FromLoc, ToLoc, count(OrderID) as Orders, Avg(Passengers), Sum(Rate) ;
>from myTable where .... order by 1,2,3 group by 1,2,3
>Works great, but in fact, the problem is i would like to have one row per trip, ie id like to have in the same line if i have FromLoc=x ToLoc=y or FromLoc=y and Toloc=x
>Any idea how to do this?
>TIA
>Jaime
If you don't care about FromLoc and ToLoc round them with aggregate function like MAX or MIN.
Be careful though, you may get unexpected results :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
