>I have the following join SQL:
>
>SELECT Apdetl.*, SUM(Appay.amount);
> FROM acctpro!apdetl LEFT OUTER JOIN acctpro!appay ;
> ON Apdetl.apdetlid = Appay.apdetlid;
> WHERE Apdetl.apmasid = 1.0000;
> ORDER BY Apdetl.ivcdate, Apdetl.ivcnum
>
You have to GROUP BY the fields you currently ORDER BY.
Also, in VFP, the GROUP BY has an implicit ORDER BY, so you don't necessarily need the ORDER BY.
Insanity: Doing the same thing over and over and expecting different results.