INSERT INTO cross SELECT a.JGJC,a.JGDM FROM (SELECT * FROM tJGDM AS a,(SELECT z.* FROM tNEWJGDM z WHERE JGDM IN (SELECT JGDM FROM tJGDM) AND (DCBJ ='0' OR DCBJ IS NULL)) AS b WHERE a.JGDM=b.JGDM) WHERE JGJC NOT IN (SELECT NEW_JGJC FROM tNEWJGDM)在access中执行正常,但是在程序中会出现3092错误~~~
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货