>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,
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