(pdo-mysql): SELECT concat(inv.SlDivCd,' - ',sld.SlDivName) as SlDivCd, concat(vch.LocCd,' - ',loc.LocName) as LocCd, cust.CustName as CustName, cust.City as City, vch.SubLdCd AS CustCd, vch.VchId as VchId, vch.VchDate as VchDate, vch.ChequeNo as ChequeNo, vch.ChequeDate as ChequeDate, inv.IGpId as IGpId, inv.InvDt as InvDt, vch.CbvRsn as CbvRsn, inv.InvAmt as InvAmt, 'sp' AS Period
FROM cbvinvdetails inv
JOIN cbvvoucher vch ON inv.cbvvoucherid = vch.cbvvoucherid
JOIN .custmst cust ON cust.CustCd=vch.SubLdCd
INNER JOIN .sldivmst sld ON inv.SlDivCd=sld.SlDivCd
INNER JOIN .a2locmst loc ON vch.LocCd=loc.LocCd
WHERE ('' IS NULL OR '' = '' OR inv.SlDivCd = '' ) AND vch.ChequeDate IS NOT NULL AND vch.VchDate BETWEEN '' AND ''
UNION ALL
SELECT concat(inv.SlDivCd,' - ',sld.SlDivName), NULL AS LocCd, NULL AS CustName, NULL AS City, NULL AS CustCd, NULL AS VchId, NULL AS VchDate, NULL AS ChequeNo, NULL AS ChequeDate, NULL AS IGpId, NULL AS InvDt, NULL AS CbvRsn, SUM(inv.InvAmt) AS InvAmt, 'spsbt' AS Period
FROM cbvinvdetails inv
JOIN cbvvoucher vch ON inv.cbvvoucherid = vch.cbvvoucherid
INNER JOIN .sldivmst sld ON inv.SlDivCd=sld.SlDivCd
WHERE ( '' IS NULL OR '' = '' OR inv.SlDivCd = '' ) AND vch.VchDate IS NOT NULL AND vch.VchDate BETWEEN '' AND ''
GROUP BY inv.SlDivCd
UNION ALL
SELECT concat(inv.SlDivCd,' - ',sld.SlDivName), NULL AS LocCd, NULL AS CustName, NULL AS City, NULL AS CustCd, NULL AS VchId, NULL AS VchDate, NULL AS ChequeNo, NULL AS ChequeDate, NULL AS IGpId, NULL AS InvDt, NULL AS CbvRsn, SUM(inv.InvAmt) AS InvAmt, 'mtd' AS Period
FROM cbvinvdetails inv
JOIN cbvvoucher vch ON inv.cbvvoucherid = vch.cbvvoucherid
INNER JOIN .sldivmst sld ON inv.SlDivCd=sld.SlDivCd
WHERE ('' IS NULL OR '' = '' OR inv.SlDivCd = '') AND vch.VchDate IS NOT NULL AND vch.VchDate BETWEEN DATE_FORMAT('', '%Y-%m-01') AND ''
GROUP BY inv.SlDivCd
ORDER BY SlDivCd, FIELD(Period, 'sp', 'spsbt', 'mtd')
1146: Table 'yashutilitty.custmst' doesn't exist
ADOConnection._Execute(SELECT concat(inv.SlDivCd,' - ',sld.SlDivName) as SlDivCd, concat(vch.LocCd,' - ',loc.LocName) as LocCd, cust.CustName as CustNa..., false) % line 1206, file: adodb.inc.php
ADOConnection.Execute(SELECT concat(inv.SlDivCd,' - ',sld.SlDivName) as SlDivCd, concat(vch.LocCd,' - ',loc.LocName) as LocCd, cust.CustName as CustNa...) % line 2554, file: index.php
blank_cbvinvdetails_daily_cheque_bouncing_report_apl.controle() % line 3210, file: index.php
DAILY CHEQUE BOUNCE REPORT FROM 01-01-1970 to 01-01-1970
DAILY CHEQUE BOUNCE REPORT 01-01-1970 to 01-01-1970