请问，是否在表格里面不能用note作为字段，下面的sql语句报语法错误，将note字段名改了就可以

[eyun]

insert into pdm_machinery(sn,edition,machinery_name,material,weight,note) select sn,edition,machinery_name,material,weight,note from pdm_machinery where and edition='0'

[ACMAIN_CHM]

insert into pdm_machinery(sn,edition,machinery_name,material,weight,[note]) select sn,edition,machinery_name,material,weight,[note] from pdm_machinery where and edition='0'

[sosoben]

什么数据库 access里面没有这个保留字哦

N-P保留字

NATIONAL  Outer* 
NCHAR  OUTPUT 
NONCLUSTERED OWNERACCESS  
Not PAD 
NTEXT  PARAMETERS  
NULL  PARTIAL 
NUMBER - 请参见 DOUBLE PASSWORD 
NUMERIC - 请参见 DECIMAL PERCENT  
NVARCHAR  PIVOT  
OCTET_LENGTH POSITION 
OLEOBJECT - 请参见 LONGBINARY PRECISION 
ON  PREPARE 
OPEN PRIMARY  
OPTION  PRIVILEGES 
Or  PROC、PROCEDURE  
ORDER  PUBLIC