Seems possible. Somehow with an order clause vfp is never finishing the processing order.
>Hi Tuvia,
>
>your issue may be related to the order in which clauses get executed
>
>
http://www.bennadel.com/blog/70-sql-query-order-of-operations.htm>
>no solution to offer, just a possible path
>
>
>>It's one of those morning after an all-nighter (which I am getting too old for) and I would appreciate it if somebody would point out my error, probably obvious:
>>
>>Works:
>>
>>
>> * REPLACED ACTUAL TABLE NAMES FOR THIS EXAMPLE:
>> SELECT a.ccompany, a.custcode, COUNT(b.req_date) as nTotal, ;
>> SUM(b.nstorage) as nStorage, SUM(b.tow_chrg) as nTows ;
>> FROM a;
>> JOIN b ON b.custcode = a.custcode;
>> WHERE b.control_no in ;
>> (SELECT towfky FROM redeem WHERE redeem.dredeemdat>= {01/01/2014} AND redeem.dredeemdat<= {12/31/2014}) ;
>> GROUP BY 1,2 ;
>> into cursor temp1 readwrite
>>>>
>>Now add the ORDER and the totals go haywire
>>
>>
>> * REPLACED ACTUAL TABLE NAMES FOR THIS EXAMPLE:
>> SELECT a.ccompany, a.custcode, COUNT(b.req_date) as nTotal, ;
>> SUM(b.nstorage) as nStorage, SUM(b.tow_chrg) as nTows ;
>> FROM a;
>> JOIN b ON b.custcode = a.custcode;
>> WHERE b.control_no in ;
>> (SELECT towfky FROM redeem WHERE redeem.dredeemdat>= {01/01/2014} AND redeem.dredeemdat<= {12/31/2014}) ;
>> GROUP BY 1,2 ;
>> ORDER BY 1,2 ;
>> into cursor temp1 readwrite
>>>>
>>TIA
