At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!
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.
Join the community of 500,000 technology professionals and ask your questions.