Warning

Error while accessing the database Table 'perputility.prefmeyer' doesn't exist select count(*) from (SELECT PqId, ItemCd, ItSrlNo, GSInd, HSNSACCd, PqQty, SaleQty, FreeQty, ManufName, VendPrdCd, MinOrdQty, MaxOrdQty, LeadTime, PActvtCd, MRP, BsRt, BsVal, AppQty01, UnitRt01, AssRt01, AssVal01, AppPct01, TCDVal01, AppQty02, UnitRt02, AssRt02, AssVal02, AppPct02, TCDVal02, AppQty03, UnitRt03, AssRt03, AssVal03, AppPct03, TCDVal03, AppQty04, UnitRt04, AssRt04, AssVal04, AppPct04, TCDVal04, AppQty05, UnitRt05, AssRt05, AssVal05, AppPct05, TCDVal05, AppQty06, UnitRt06, AssRt06, AssVal06, AppPct06, TCDVal06, AppQty07, UnitRt07, AssRt07, AssVal07, AppPct07, TCDVal07, AppQty08, UnitRt08, AssRt08, AssVal08, AppPct08, TCDVal08, AppQty09, UnitRt09, AssRt09, AssVal09, AppPct09, TCDVal09, AppQty10, UnitRt10, AssRt10, AssVal10, AppPct10, TCDVal10, AppQty11, UnitRt11, AssRt11, AssVal11, AppPct11, TCDVal11, AppQty12, UnitRt12, AssRt12, AssVal12, AppPct12, TCDVal12, ItDsVal, ItTcVal, GrVal, OhBlVal, TotBlVal, PrBlVal, IOvhAsVl01, IOvhRt01, IOvhVal01, IOvhAsVl02, IOvhRt02, IOvhVal02, IOvhAsVl03, IOvhRt03, IOvhVal03, IOvhAsVl04, IOvhRt04, IOvhVal04, IOvhAsVl05, IOvhRt05, IOvhVal05, IOvhVal06, IOvhVal07, IOvhVal08, IOvhVal09, DOvhVal01, DOvhVal02, DOvhVal03, DOvhVal04, DOvhVal05, TotOvhVal, VatClmVal, OhDCVal, OhMatVal, EffVal, VlRt, IsApprv, ApprovDt, LocCd, YrId, TxTpCd, PqDt, PrGrpCd, VendorCd, PrcMdlCd, TrCurCd, TrToPrRt, RfqId, TpPur, LBTAppl, PqCat, JbwHSNCd, IsSEZ, GSTIN, rdbts, (SELECT PayTermCd FROM pqhd hd WHERE hd.PqId = pq.PqId LIMIT 1) AS PaymentTermsCode, (SELECT CrdPrd FROM pqhd hd WHERE hd.PqId = pq.PqId LIMIT 1) AS CreditPeriod, (SELECT h.PqRctDt FROM pqhd h WHERE h.PqId = pq.PqId LIMIT 1) AS ReceivedDate, (SELECT h.ValidPrd FROM pqhd h WHERE h.PqId = pq.PqId LIMIT 1) AS ValidDays, (SELECT DATE_ADD(h.PqRctDt, INTERVAL h.ValidPrd DAY) FROM pqhd h WHERE h.PqId = pq.PqId LIMIT 1) AS ValidTill FROM pqdt pq JOIN `perputility`.prefmeyer ON 1=1 where Itemcd ="" AND pq.PqQty BETWEEN ( (SELECT pr.PrqQty FROM prqdt pr WHERE pr.ItemCd = "") - (SELECT PQTTolerQty FROM `perputility`.prefmeyer) ) AND ( (SELECT pr.PrqQty FROM prqdt pr WHERE pr.ItemCd = "") + (SELECT PQTTolerQty FROM `perputility`.prefmeyer) ) ) nm_sel_esp