Question

access的insert语句可以嵌套select语句吗？ 我该怎么改下面的语句？

INSERT INTO NC_SoftList (softname,context,homepage,softtime,classid,softsize,impower,Languages,runsystem,star,isbest,isupdate,isaccept) values
('test','test','test',CDate('2007-06-06 06:39:39'),SELECT NC_Classify.ClassID FROM NC_Classify where classname='广告排行','test','test','test','test','3','1','1','1')

Answer 1

INSERT INTO NC_SoftList (softname,context,homepage,softtime,classid,softsize,impower,Languages,runsystem,star,isbest,isupdate,isaccept) select
('test','test','test',CDate('2007-06-06 06:39:39'),NC_Classify.ClassID,'test','test','test','test','3','1','1','1' FROM NC_Classify where classname='广告排行')

Answer 2

这样似乎不行