Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.
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?
Add your voice to the tech community where 5M+ people just like you are talking about what matters.