ExecSP:SQL= INSERT INTO WH_KCDETAILUPDATETEMP  SELECT a.D013 AS D010,a.D213 AS D212,-SUM((iif(ISNULL(a.D017),0,a.D017)*iif(ISNULL(d.M016),0,d.M016)) * iif(ISNULL(b.M013),0,b.M013)) AS M500 FROM PL_PTGIND AS a , PL_PTGINM AS c ,SYS_P_BILLSETM d,BS_B_MEASUREUNIT b  WHERE a.D001='D02'  AND ABS(iif(ISNULL(a.D017),0,a.D017)) > 0  AND c.M001=a.D001 AND c.M002=a.D002  AND c.M202=1 AND CDATE(CStr(YEAR(iif(ISNULL(c.M004),'2012-01-01',c.M004))) + '-' + CStr(MONTH(iif(ISNULL(c.M004),'2012-01-01',c.M004))) + '-' + CStr(DAY(iif(ISNULL(c.M004),'2012-01-01',c.M004))))>='2015-08-01'  AND CDATE(CStr(YEAR(iif(ISNULL(c.M004),'2012-01-01',c.M004))) + '-' + CStr(MONTH(iif(ISNULL(c.M004),'2012-01-01',c.M004))) + '-' + CStr(DAY(iif(ISNULL(c.M004),'2012-01-01',c.M004)))) <='2015-08-31'  AND '002' LIKE '%'+c.M003+'%'  AND d.M001='D02' AND d.M011='fplPTGIN' AND d.M021=c.M003  AND a.D015=b.M019 AND b.M001='D02'  GROUP BY a.D013,a.D213 ; error:Microsoft Jet 数据库引擎找不到输入表或查询 'PL_PTGIND'。 确定它是否存在，以及它的名称的拼写是否正确。
