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