>Tried the following query in VFP9, VFP8, and VFP7. Records returned were 226, 236, and 232 respectively. I was expecting 263 because that is the number of records in the table on the left, RoseBran. Can anyone see what I'm missing here?
>

>SELECT RoseBran.ItemNo, ;
>       RoseBran.Descrip, ;
>       RoseBran.Descrip1, ;
>       SUM(ARSTrans.Shipped) as Shipped ;
>  FROM RoseBran ;
>  LEFT OUTER JOIN ARSTrans ;
>    ON RoseBran.ItemNo = ARSTrans.ItemNo ;
> WHERE BETWEEN(ARSTrans.DateShip,CTOD('2005/01/01'),DATE()) ;
> GROUP BY 1, 2, 3 ;
> ORDER BY 1 ;
>  INTO CURSOR TEMP
>

>TIA,

the correct is:

SELECT RoseBran.ItemNo, ;
       RoseBran.Descrip, ;
       RoseBran.Descrip1, ;
       SUM(ARSTrans.Shipped) as Shipped ;
  FROM RoseBran ;
  LEFT OUTER JOIN ARSTrans ;
    ON RoseBran.ItemNo = ARSTrans.ItemNo ;
 AND BETWEEN(ARSTrans.DateShip,CTOD('2005/01/01'),DATE()) ;
 GROUP BY 1, 2, 3 ;
; && ORDER BY 1 on VFP this is useless
  INTO CURSOR TEMP