Question

access查询值的数目与目标字段中的数目不同

insert into tbLog(opertypeid,aid,account,name,ip,intro)
select top 1 c.id as opertypeid,t.* from(
SELECT a.id as aid, a.account as account, b.name as name,'ip' as ip,'introasdffffff' as intro
FROM tbadmin AS a
LEFT JOIN tbemployee AS b ON a.id=b.id
WHERE a.id='0001'
) t,tbdictionaryvalue c where c.sn='SYS_RZLX_DL'

(opertypeid,aid,account,name,ip,intro)这里面需要插入6个字段,后面我插入的也是6个字段,我都数了,是相同的,不知道哪里不同了
ps:同样的语句,我还专门在SqlServer里面建表测试,SqlServer里面都插入成功了,access里面报查询值的数目与目标字段中的数目不同





• 你的回答被采纳后将获得：
• 系统奖励15（财富值+成长值）+难题奖励30（财富值+成长值）

Answer 1

你可以减少语句的复杂程度。有可能Access语法不通过