SELECT ITM.ITEM_ID , SUM(ILI.LOCT_ONHAND) , SUM(ILI.LOCT_ONHAND2) FROM IC_ITEM_MST ITM, IC_LOCT_INV ILI WHERE ITM.ITEM_ID = ILI.ITEM_ID AND ILI.DELETE_MARK = 0 AND ITM.DELETE_MARK = 0 GROUP BY ITM.ITEM_ID
View Text - HTML Formatted
SELECT ITM.ITEM_ID , SUM(ILI.LOCT_ONHAND) , SUM(ILI.LOCT_ONHAND2) FROM IC_ITEM_MST ITM , IC_LOCT_INV ILI WHERE ITM.ITEM_ID = ILI.ITEM_ID AND ILI.DELETE_MARK = 0 AND ITM.DELETE_MARK = 0 GROUP BY ITM.ITEM_ID