We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
SELECT sm.skuId as sku, sm.tlcDescription as item , (SELECT count(t.tallyId) as shp FROM Tally t WHERE t.status='Transit' group by t.skuMaster.skuId ), (SELECT count(t.tallyId) as stk FROM Tally t WHERE t.status='Stock' group by t.skuMaster.skuId), (SELECT count(t.tallyId) as dlv FROM Tally t WHERE t.status = ('Invoice') group by t.skuMaster.skuId) from SkuMaster sm LEFT JOIN .......... ? sm.tally.skuId?
Join the community of 500,000 technology professionals and ask your questions.