Warning

Error while accessing the database Table 'erptest.mgmst' doesn't exist select count(*) from (SELECT sldivcd, (select mgname from erptest.mgmst WHERE mgcd=SUBSTRING(t1.mgcd,1,2) LIMIT 1) AS ZM, (select mgname from erptest.mgmst WHERE mgcd=SUBSTRING(t1.mgcd,1,3) LIMIT 1) AS DM, (select mgname from erptest.mgmst WHERE mgcd=SUBSTRING(t1.mgcd,1,4) LIMIT 1) AS RM, (select mgname from erptest.mgmst WHERE mgcd=(t1.mgcd) LIMIT 1) AS HQ,MgCd, custcd,itemcd,targetVal,sum(saleQty) AS saleQty,(SaleQty) as SaleVal,sum(AdFrQty) AS AdFrQty,sum(AdFrVal) AS AdFrVal,sum(SrnSaleQty) AS SrnSaleQty,sum(SrnSaleVal) AS SrnSaleVal,sum(saleQty+SrnSaleQty) AS NetSaleQty,sum(SaleVal+SrnSaleVal) AS NetSaleVal FROM (SELECT sldivcd,mgcd,custcd,itemcd,0 as targetVal,txtpcd, if(txtpcd !='SRN',SaleQty,0) as saleQty, if(txtpcd !='SRN',saleqty*salerate,0) as SaleVal, extraFree as AdFrQty,extraFree*salerate as AdFrVal, if(txtpcd ='SRN',SaleQty,0) as SrnSaleQty, if(txtpcd ='SRN',saleqty*salerate,0) as SrnSaleVal FROM salesreport WHERE yrmonth=DATE_FORMAT(CURDATE() - INTERVAL 1 month,'%Y/%m')) t1 GROUP BY custcd,itemcd,mgcd ) nm_sel_esp