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