>SELECT 0000000000+SUM(NVL(WeekShips.Shipped,0)) AS nShipped, ; > 0000000000+SUM(NVL(WeekSales.Sales,0)) AS WeekSales, ; > 0000000000+SUM(NVL(YTDSales.Sales,0)) AS YTDSales, ; > ItemSetup.Retail, 0000000000+NVL(iciwhs.nOnHand,0) AS nOnHand ; > FROM ItemSetup ; > INNER JOIN ItemSales ON ItemSetup.cItemNo = ItemSales.cItemNo ; > AND ItemSales.Category = "TRANSFER" ; > LEFT JOIN WeekShips ON WeekShips.cItemNo = ItemSetup.cItemNo ; > LEFT JOIN WeekSales ON WeekSales.UnitRetail = ItemSetup.Retail ; > LEFT JOIN IciWhs ON iciWhs.cItemNo = ItemSetup.cItemNo ; > LEFT JOIN YTDSales ON YTDSales.UnitRetail = ItemSetup.Retail ; > ORDER BY ItemSetup.Retail, nOnHand ; > GROUP BY ItemSetup.Retail, nOnHand ; > HAVING YTDSales > 0 ; > INTO CURSOR SpreadsheetResults >>