ExecSP:SQL= INSERT INTO WH_KCDETAILUPDATETEMP  SELECT a.D010 AS D010,a.D020 AS D212,+SUM((iif(ISNULL(a.D015),0,a.D015)*iif(ISNULL(d.M016),0,d.M016)) * iif(ISNULL(b.M013),0,b.M013)) AS M500 FROM WH_TZD AS a , WH_TZM AS c ,SYS_P_BILLSETM d,BS_B_MEASUREUNIT b  WHERE a.D001='D02'  AND ABS(iif(ISNULL(a.D015),0,a.D015)) > 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-06-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-06-30'  AND '001' LIKE '%'+c.M003+'%'  AND d.M001='D02' AND d.M011='fwhTZ' AND d.M021=c.M003  AND a.D012=b.M019 AND b.M001='D02'  GROUP BY a.D010,a.D020 ; error:Microsoft Jet 数据库引擎找不到输入表或查询 'WH_TZD'。 确定它是否存在，以及它的名称的拼写是否正确。
