Try (VFP9 only)

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

>>Try to change WHERE clause to

WHERE BETWEEN(ARSTrans.DateShip,CTOD('2005/01/01'),DATE()) OR ARSTrans.DateShip IS NULL) ;

>>
>>
>>>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?
>
>
>Sergey,
>
>I think that's the solution, although the results were only 262. Not sure about the missing record - but its a heck of a lot closer.
>

--sb--