>I am doing a select against a table with a group by clause, I wish to have the cursor contain the min and max values for the group, I am not getting the correct values. the select is as follows :
>sele district,route,min(odometer) as begin_point, .f. as found_beg, max(odometer) as end_point, .f. as found_end ;
>from pcs!pcs_locations group by district,route into cursor log_data
>
>TIA
>Ian
Seems this ought to work, although I can't say that I've done a lot of commands that combine MIN and MAX. If you separate this into 2 separate queries, do you get the correct results?