>ORDER BY 2,1 ; >>
>>SELECT Customer.code, Min(Ordhead.daterequired),Max(Ordhead.daterequired) ; >>FROM frantisi!ordhead, Customer ; >>WHERE OrdHead.CustomerID= Customer.CustomerID ; >>GROUP BY customer.code ; >>ORDER BY DateRequired ,Customer.Code ; >>INTO cursor Temp >>>above query works fine in VFP7 but fails with "Order by clause is invalid"